cancel
Showing results for 
Search instead for 
Did you mean: 

Getting DB result for Bulgarian Cyrilic in testComplete

SOLVED
kixosvk
New Contributor

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...

1 ACCEPTED SOLUTION

Accepted Solutions
tphillips
Frequent Contributor

Re: Getting DB result for Bulgarian Cyrilic in testComplete

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


--------------------
QA Systems Architect

View solution in original post

2 REPLIES 2
tphillips
Frequent Contributor

Re: Getting DB result for Bulgarian Cyrilic in testComplete

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


--------------------
QA Systems Architect

View solution in original post

sonya_m
Community Manager

Re: Getting DB result for Bulgarian Cyrilic in testComplete

Thanks for the advice tphillips!

 

@kixosvk  does this help?


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements