Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2008
    Posts
    40

    Unanswered: Japnese characters in utf 8 db

    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

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jun 2008
    Posts
    40
    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

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Last edited by przytula_guy; 04-09-09 at 04:39.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jun 2008
    Posts
    40
    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 ?

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by jayawant01
    I can't see Japanese char until i change my locale to ja ?
    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.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •