Hi all,
I have a utf 8 database and want to insert japnase characters in it . Is it possible ? if yes then what are the limitations in doing that .

Thanks

have a look in developers work - some articles on this
Setting Up a Mixed-Byte Character Set (MBCS) Database on an English OS in DB2 UDB Version 8
and yes, all languages are supported

hi , the above article talks about creating mbcs db whose code set is different from utf -8.
Also when i tried to insert a japanaese charcter on the aix prompt it converted into a "?" i also tried using
iconv -f UCS-2 -t UTF-8 jap.csv >conv.csv
this time it converted it into some junk characters
kindly help

have a look in dev.work other articles talk about this
the prompt of unix has to be customized to enter characters in specific language. see nls_lang ..
the display of characters is handled by the command prompt settings
in dev.work there is an article how to setup a workstation to support japanes characters
check also this article
http://www.ibm.com/developerworks/da...u/0210lau.html

Hi ,
Link to other articles are currently unavailable. Correct me if I am wrong .
I cant see Japnese char untill i change my locale to ja ?

if your terminal does not support japanese characters, how can you display them otherwise??
the terminal/station needs all support to convert the display to correct character

It could be a matter of installed fonts.
Have a look at the Unibook Character Browser where you will find an application that displays any UTF-8 character, provided it finds the necessary fonts.
If this works, I would suggest using an UTF-8 aware graphical editor like e.g. CoolEdit (http://cooledit.sourceforge.net/), gvim (vim), Emacs, Netscape Composer, or others, to enter and/or read your Japanese text in UTF-8.
If this also works fine, you can be certain that what's stored in DB2 is really what you want it to be, even if it shows up as "?????" or as seemingly junk characters in some interfaces.