MQSeries.net :: View topic - Problem in inserting Chinese characters in DB2

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem in inserting Chinese characters in DB2

Problem in inserting Chinese characters in DB2

« View previous topic :: View next topic »

Author

Message

abhyyy

Posted: Sun Jan 15, 2012 9:54 am Post subject: Problem in inserting Chinese characters in DB2

Voyager

Joined: 29 Sep 2011
Posts: 83

Hi Friends,

I am trying to insert chinese characters into DB2 but DB2 doesnt get updated correctly and chinese chars are shown as boxes. Is there a way we can insert chinese/japanese characters into DB2?
_________________
----------------------
NeVeR StOp LeaRnInG.

smdavies99

Posted: Sun Jan 15, 2012 10:34 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Has your DB2 database been created with the right CCSID?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

rekarm01

Posted: Sun Jan 15, 2012 1:39 pm Post subject: Re: Problem in inserting Chinese characters in DB2

Grand Master

Joined: 25 Jun 2008
Posts: 1415

Check the InfoCenter for Support for Unicode in databases.

abhyyy

Posted: Wed Jan 18, 2012 7:55 pm Post subject:

Voyager

Joined: 29 Sep 2011
Posts: 83

My DB2 properties show that it supports UTF-8 and CCSID is 1208. I am just not able to see Chinese ccharacters in the control center but inserting/retreiving is working perfectly fine now using esql in compute node.
_________________
----------------------
NeVeR StOp LeaRnInG.

smdavies99

Posted: Wed Jan 18, 2012 11:01 pm Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

abhyyy wrote:

I am just not able to see Chinese ccharacters in the control center

You might get better results if you use the DB2 Data Studio for this. IT is a free download from IBM.

If that fails then it might be time for a PMR against DB2
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem in inserting Chinese characters in DB2

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP