IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2012-10-15T12:32:04Z by engur
engur
engur
22 Posts

Pinned topic DB2 express ver.10 National character support problem

‏2012-10-14T09:55:40Z |
I am using windows xp prof english with serv pack3 using English national language.
I had DB2 ver 8.14 enterprise ed. on this machine using almost 5 years.
I develop application using IBM pli for windows with embeded sql.
So far every thing was good.
After uninstalling DB2 ver 8.14 and installing db2 express ver 10. and creating databases and binding programs I have a strange problems on certain situation.

Whenever I try to insert data using our developed programs we are getting sqlcode -302 for these situation ;
Putting our national characters upper and lover case letters of: ÖÇŞİĞÜ/öçşğü nearby any special charaters like -*
1) I can update required tables using IBM Data studio.
2) I recompile and bind our program against new db2 ver 10. But nothing changed.
3) I am attaching output of the "get db cfg" result.

Can I get help or should I return the ver 8.14 ?

Kind regards.

Mehmet Engur

Attachments

Updated on 2012-10-15T12:32:04Z at 2012-10-15T12:32:04Z by engur
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: DB2 express ver.10 National character support problem

    ‏2012-10-15T11:37:45Z  
    Hello,

    Your database code set is UTF-8. I suspect your application does not use the UTF-8 code set.

    Either change your application to use UTF-8, or use the same database code set in DB2 10.1 as you were using in DB2 8.1.4.

    Regards.

    Yves-Antoine Emmanuelli
  • engur
    engur
    22 Posts

    Re: DB2 express ver.10 National character support problem

    ‏2012-10-15T11:40:40Z  
    One more problem ; I can not enter Turkish charecters on db2 command window.
    Even though I am able to enter these charecters and update db2 using data studio program.

    Mehmet Engur
  • engur
    engur
    22 Posts

    Re: DB2 express ver.10 National character support problem

    ‏2012-10-15T12:32:04Z  
    Hello,

    Your database code set is UTF-8. I suspect your application does not use the UTF-8 code set.

    Either change your application to use UTF-8, or use the same database code set in DB2 10.1 as you were using in DB2 8.1.4.

    Regards.

    Yves-Antoine Emmanuelli
    Hello Emmanuelli,

    Thanks for your kind help.
    After creating database with our code set problem is over.
    However stil db2 command line does not display our national characters correctly, even though it updates with correct charecters.
    How can this problem be solved ?

    Kind Regards.

    Mehmet Engur