Getting DB result for Bulgarian Cyrilic in testComplete

[kixosvk]

Hello to everyone, 

i have following problem.

Im using ADO.CreateADOConnection() apporoach to getting results from oracle DB , via ODBC connections , created in OS.

But when i want to get text stored in DB as following (BLG cyrilic):

Райфайзенбанк Ви информира, че може да получите новата си карта

I got this :

¿¿¿¿¿¿¿¿¿¿¿¿¿ ¿¿ ¿¿¿¿¿¿¿¿¿, ¿¿ ¿¿¿¿ ¿¿ ¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿ ¿¿ ¿¿¿¿¿

In for example SQL developer result is fine.

Here is my "dummy" code for getting results:

var sql = "select text from notification_text where lang = 'BLC'"
var aCon = ADO.CreateADOConnection()
aCon.ConnectionString = 'Data Source=ODBC_DB_NAME;Password=psswd'
aCon.LoginPrompt = false
aCon.Open()
var rSet = aCon.Execute_(sql)
var result = rSet.Fields.Item(0).Value
Log.Message(result)

THX for help...

[tphillips · Accepted solution]

What happens if you inspect rSet.Fields.Item(0)? Does it have any other properties/methods that might give you what you want?

Does it do the same if you use ADO.CreateADOQuery() instead of ADO.CreateADOConnection()?

[sonya_m]

Thanks for the advice tphillips!

@kixosvk  does this help?