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 ?
Pinned topic DB2 express ver.10 National character support problem
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-15T12:32:04Z at 2012-10-15T12:32:04Z by engur
SystemAdmin 110000D4XK5837 Posts
Re: DB2 express ver.10 National character support problem2012-10-15T11:37:45ZThis is the accepted answer. This is the accepted answer.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.
Re: DB2 express ver.10 National character support problem2012-10-15T11:40:40ZThis is the accepted answer. This is the accepted answer.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.
Re: DB2 express ver.10 National character support problem2012-10-15T12:32:04ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
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 ?