asked on

Powerbuilder - Bulgarian (cyrillic) characters

Hi!

Could anybody help me?
I use powerbuilder 11 and I have problems with updating cyrillic characters into database columns thru datawindow. So, I paste cyrillic letters on some datawindow column, no problem - they are displayed well, but when I press "Save" (updating dw), the cyrillic letters disappear and "???" appear instead. We use MSS 2008 and when I paste these letters directly into table's column from Management Studio, it works.
So, maybe I have to set some DBParm variable?

Thank you!

Harish Varghese

Hello,

Did you check what value goes into the table when you update the DW?

Thanks,
Harish

stefan1967

ASKER

Yes: '???'
:(

stefan1967

ASKER

My DBMS is:

SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"

I also tried to change dynamically the font.charset to "204" of each CHAR field of DW:

dw.Modify(ls_colname + '.font.charset = "204"')

But didn't work...

Harish Varghese

Forgot to ask you.. which version of PB are you using?

stefan1967

ASKER

PB 11

Thanks!

stefan1967

ASKER

Other observation is that when I update column in Management Studio like this:

update TableName set ColumnName = 'some cyrillic string' where id = 2,

it doesn't work. The value is set to '???'

But if I run:

update TableName set ColumnName = N'some cyrillic string' where id = 2,

with N prefix, it is OK.

Harish Varghese

I tried with some other languages in PB 9.0 and it works fine without any special handlings. Unfortunately, I dont have PB 11.0 with me.
Do you have PB 9.0 by any chance? Can you please confirm if you are facing the same issue in PB9.0 as well?
Also, what is the name of the font you are using? Let me give a try.

Thanks,
Harish

ASKER CERTIFIED SOLUTION

stefan1967

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

stefan1967

ASKER

My last post is a possible solution of the problem. Not a general, but since it works, I close this question.