Getting DB result for Bulgarian Cyrilic in testComplete
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...
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()?