Solved

Powerbuilder - Bulgarian (cyrillic) characters

Posted on 2012-04-07
9
601 Views
Last Modified: 2012-05-12
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!
0
Comment
Question by:stefan1967
  • 6
  • 3
9 Comments
 
LVL 12

Expert Comment

by:Harish Varghese
ID: 37831392
Hello,

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

Thanks,
Harish
0
 

Author Comment

by:stefan1967
ID: 37831718
Yes: '???'  
 :(
0
 

Author Comment

by:stefan1967
ID: 37831774
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...
0
 
LVL 12

Expert Comment

by:Harish Varghese
ID: 37831859
Forgot to ask you.. which version of PB are you using?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:stefan1967
ID: 37831866
PB 11

Thanks!
0
 

Author Comment

by:stefan1967
ID: 37836278
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.
0
 
LVL 12

Expert Comment

by:Harish Varghese
ID: 37838819
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
0
 

Accepted Solution

by:
stefan1967 earned 0 total points
ID: 37839269
Well, as I wrote in the previous comment, the problem was that in MSSQL command like:

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

does not work properly. It puts '?????'.

The proper way is:
update  TableName  set  ColumnName = N'some cyrillic string'  where  id = 2.

So, today I hacked in the sqlpreview event of my DW parentobject the sqlsyntax with adding 'N' before every starting quote. Now it works well from datawindow and maybe my bosses will be happy, but this is not general solution, because updates and inserts happen not only from DW.
I hoped, there is some MSSQL or client-server's variable setting, which results the wished behavior.
Anyway, I'll keep this question opened for a couple of days more, and then close it.

Thank you, Harish, for the help! Maybe we'll meet soon, because I have got another pretty problem. :)
0
 

Author Closing Comment

by:stefan1967
ID: 37959942
My last post is a possible solution of the problem. Not a general, but since it works, I close this question.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now