Forum Discussion

kixosvk's avatar
kixosvk
New Contributor
4 years ago
Solved

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()?

2 Replies

  • tphillips's avatar
    tphillips
    Frequent Contributor

    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's avatar
      sonya_m
      SmartBear Alumni (Retired)

      Thanks for the advice tphillips!

       

      kixosvk  does this help?