Solved

Powerbuilder - Bulgarian (cyrillic) characters

Posted on 2012-04-07
9
611 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 12

Expert Comment

by:Harish Varghese
ID: 37831859
Forgot to ask you.. which version of PB are you using?
0
 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

696 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