Skip to Content

Arabic save issue powerbuilder and mysql

I cannot save Arabic description in powerbuilder 10.5 with MySQL 5.6. I have already done the same with SQLAnywhere 9 and 10 and there was no problem occurred.I think the problem is with Powerbuilder with MySQL.Please help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2015 at 03:23 PM

    Hi Ajimon;

    You need to specify that you are using Unicode characters in your columns. Normally, most DBMS specify this as data type NvarChar or NChar. In MySQL though, you would use either:

    VARCHAR(n) CHARSET utf8

    or

    VARCHAR(n) CHARSET ucs2

    PS: the default character set if you don't specify it is ANSI. Thus, no Arabic support as you need the "extended" character set.

    HTH

    Regards ... Chris

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ajimon Yohannan

      Hi Ajimon;

      If you chose the USC2 option I would not be surprised that viewing the data with other non Unicode compliant tools would be an issue. If you chose the UTF-8 option then characters should display OK in other SQL tools that are compliant to that universal character set. The other issue is if the SQL tool ou are using knows how to handle nVarChar like PB does.

      Is this an issue only when using other SQL tools for say like direct reporting vs using PB's DataWindow?

      Regards ... Chris

  • Posted on Aug 06, 2015 at 08:21 AM

    What do you mean with "Arabic decription"? Do you want to store Arabic data in the database?

    What character set do you use in the database? ( http://stackoverflow.com/questions/6859018/save-data-in-arabic-in-mysql-database )

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.