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...
Solved! Go to 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()?
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()?
Thanks for the advice tphillips!
@kixosvk does this help?