Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    33

    Unanswered: DB2 Control Center insert chinese characters problem

    Hello,

    I have a problem dealing with Chinese characters.

    Im trying to insert XML data (in Chinese characters) via DB2 Control Center from client computer to DB2 server running on Debian.

    The insert process is successful but the result shows some � symbols if I using the DB2 CC Command Editor.

    However, there is no such problem if I perform either below.
    • insert the data via putty from client.
    • use import command to import the data via DB2 Control Center.

    The stored Chinese characters can be displayed well without any � via DB2 Control Center.


    Ive found some articles related to the problem, but dont know how to apply it.

    The articles are form URL below
    IBM How to display unicode characters (including DBCS) in DB2 Control Center on an English Windows environment. - United States
    IBM Control Center unable to display chinese characters - United States

    This is my setting for fontconfig.properties.src
    Code:
    # @(#)fontconfig.properties	1.5 04/01/28
    
    version=1
    # Component Font Mappings
    
    allfonts.arialunicodems=Arial Unicode MS
    allfonts.chinese-ms936=SimSun
    allfonts.chinese-gb18030=SimSun-18030
    allfonts.chinese-gb18030-extb=SimSun-ExtB
    allfonts.chinese-hkscs=MingLiU_HKSCS
    allfonts.devanagari=Mangal
    allfonts.dingbats=Wingdings
    allfonts.gujurati=Shrti
    allfonts.kannada=Tunga
    allfonts.lucida=Lucida Sans Regular
    allfonts.punjabi=Raavi
    allfonts.symbol=Symbol
    allfonts.tamil=Latha
    allfonts.telegu=Gautami
    allfonts.thai=Lucida Sans Regular
    
    serif.plain.alphabetic=Times New Roman
    serif.plain.chinese-ms950=MingLiU
    serif.plain.hebrew=David
    serif.plain.japanese=MS Mincho
    serif.plain.korean=Batang
    
    serif.bold.alphabetic=Times New Roman Bold
    serif.bold.chinese-ms950=PMingLiU
    serif.bold.hebrew=David Bold
    serif.bold.japanese=MS Mincho
    serif.bold.korean=Batang
    
    serif.italic.alphabetic=Times New Roman Italic
    serif.italic.chinese-ms950=PMingLiU
    serif.italic.hebrew=David
    serif.italic.japanese=MS Mincho
    serif.italic.korean=Batang
    
    serif.bolditalic.alphabetic=Times New Roman Bold Italic
    serif.bolditalic.chinese-ms950=PMingLiU
    serif.bolditalic.hebrew=David Bold
    serif.bolditalic.japanese=MS Mincho
    serif.bolditalic.korean=Batang
    
    sansserif.plain.alphabetic=Arial
    sansserif.plain.chinese-ms950=MingLiU
    sansserif.plain.hebrew=David
    sansserif.plain.japanese=MS Gothic
    sansserif.plain.korean=Gulim
    
    sansserif.bold.alphabetic=Arial Bold
    sansserif.bold.chinese-ms950=PMingLiU
    sansserif.bold.hebrew=David Bold
    sansserif.bold.japanese=MS Gothic
    sansserif.bold.korean=Gulim
    
    sansserif.italic.alphabetic=Arial Italic
    sansserif.italic.chinese-ms950=PMingLiU
    sansserif.italic.hebrew=David
    sansserif.italic.japanese=MS Gothic
    sansserif.italic.korean=Gulim
    
    sansserif.bolditalic.alphabetic=Arial Bold Italic
    sansserif.bolditalic.chinese-ms950=PMingLiU
    sansserif.bolditalic.hebrew=David Bold
    sansserif.bolditalic.japanese=MS Gothic
    sansserif.bolditalic.korean=Gulim
    
    monospaced.plain.alphabetic=Courier New
    monospaced.plain.chinese-ms950=MingLiU
    monospaced.plain.hebrew=David
    monospaced.plain.japanese=MS Gothic
    monospaced.plain.korean=GulimChe
    
    monospaced.bold.alphabetic=Courier New Bold
    monospaced.bold.chinese-ms950=PMingLiU
    monospaced.bold.hebrew=David Bold
    monospaced.bold.japanese=MS Gothic
    monospaced.bold.korean=GulimChe
    
    monospaced.italic.alphabetic=Courier New Italic
    monospaced.italic.chinese-ms950=PMingLiU
    monospaced.italic.hebrew=David
    monospaced.italic.japanese=MS Gothic
    monospaced.italic.korean=GulimChe
    
    monospaced.bolditalic.alphabetic=Courier New Bold Italic
    monospaced.bolditalic.chinese-ms950=PMingLiU
    monospaced.bolditalic.hebrew=David Bold
    monospaced.bolditalic.japanese=MS Gothic
    monospaced.bolditalic.korean=GulimChe
    
    dialog.plain.alphabetic=Arial
    dialog.plain.chinese-ms950=MingLiU
    dialog.plain.hebrew=David
    dialog.plain.japanese=MS Gothic
    dialog.plain.korean=Gulim
    
    dialog.bold.alphabetic=Arial Bold
    dialog.bold.chinese-ms950=PMingLiU
    dialog.bold.hebrew=David Bold
    dialog.bold.japanese=MS Gothic
    dialog.bold.korean=Gulim
    
    dialog.italic.alphabetic=Arial Italic
    dialog.italic.chinese-ms950=PMingLiU
    dialog.italic.hebrew=David
    dialog.italic.japanese=MS Gothic
    dialog.italic.korean=Gulim
    
    dialog.bolditalic.alphabetic=Arial Bold Italic
    dialog.bolditalic.chinese-ms950=PMingLiU
    dialog.bolditalic.hebrew=David Bold
    dialog.bolditalic.japanese=MS Gothic
    dialog.bolditalic.korean=Gulim
    #
    dialog.bolditalic.3=TSC FMing S TT
    
    dialoginput.plain.alphabetic=Courier New
    dialoginput.plain.chinese-ms950=MingLiU
    dialoginput.plain.hebrew=David
    dialoginput.plain.japanese=MS Gothic
    dialoginput.plain.korean=Gulim
    
    dialoginput.bold.alphabetic=Courier New Bold
    dialoginput.bold.chinese-ms950=PMingLiU
    dialoginput.bold.hebrew=David Bold
    dialoginput.bold.japanese=MS Gothic
    dialoginput.bold.korean=Gulim
    
    dialoginput.italic.alphabetic=Courier New Italic
    dialoginput.italic.chinese-ms950=PMingLiU
    dialoginput.italic.hebrew=David
    dialoginput.italic.japanese=MS Gothic
    dialoginput.italic.korean=Gulim
    
    dialoginput.bolditalic.alphabetic=Courier New Bold Italic
    dialoginput.bolditalic.chinese-ms950=PMingLiU
    dialoginput.bolditalic.hebrew=David Bold
    dialoginput.bolditalic.japanese=MS Gothic
    dialoginput.bolditalic.korean=Gulim
    
    # Search Sequences
    
    sequence.allfonts=alphabetic/default,dingbats,symbol
    
    sequence.serif.GBK=alphabetic,chinese-ms936,dingbats,symbol
    sequence.sansserif.GBK=alphabetic,chinese-ms936,dingbats,symbol
    sequence.monospaced.GBK=chinese-ms936,alphabetic,dingbats,symbol
    sequence.dialog.GBK=alphabetic,chinese-ms936,dingbats,symbol
    sequence.dialoginput.GBK=alphabetic,chinese-ms936,dingbats,symbol
    
    sequence.serif.GB18030=alphabetic,chinese-gb18030,dingbats,symbol
    sequence.sansserif.GB18030=alphabetic,chinese-gb18030,dingbats,symbol
    sequence.monospaced.GB18030=chinese-gb18030,alphabetic,dingbats,symbol
    sequence.dialog.GB18030=alphabetic,chinese-gb18030,dingbats,symbol
    sequence.dialoginput.GB18030=alphabetic,chinese-gb18030,dingbats,symbol
    
    sequence.serif.x-windows-950=alphabetic,chinese-ms950,dingbats,symbol
    sequence.sansserif.x-windows-950=alphabetic,chinese-ms950,dingbats,symbol
    sequence.monospaced.x-windows-950=chinese-ms950,alphabetic,dingbats,symbol
    sequence.dialog.x-windows-950=alphabetic,chinese-ms950,dingbats,symbol
    sequence.dialoginput.x-windows-950=alphabetic,chinese-ms950,dingbats,symbol
    
    sequence.serif.x-MS950-HKSCS=alphabetic,chinese-ms950,chinese-hkscs,dingbats,symbol
    sequence.sansserif.x-MS950-HKSCS=alphabetic,chinese-ms950,chinese-hkscs,dingbats,symbol
    sequence.monospaced.x-MS950-HKSCS=chinese-ms950,alphabetic,chinese-hkscs,dingbats,symbol
    sequence.dialog.x-MS950-HKSCS=alphabetic,chinese-ms950,chinese-hkscs,dingbats,symbol
    sequence.dialoginput.x-MS950-HKSCS=alphabetic,chinese-ms950,chinese-hkscs,dingbats,symbol
    
    sequence.allfonts.UTF-8.hi=alphabetic/1252,devanagari,dingbats,symbol
    
    sequence.allfonts.windows-1255=hebrew,alphabetic/1252,dingbats,symbol
    
    sequence.serif.windows-31j=alphabetic,japanese,dingbats,symbol
    sequence.sansserif.windows-31j=alphabetic,japanese,dingbats,symbol
    sequence.monospaced.windows-31j=japanese,alphabetic,dingbats,symbol
    sequence.dialog.windows-31j=alphabetic,japanese,dingbats,symbol
    sequence.dialoginput.windows-31j=alphabetic,japanese,dingbats,symbol
    
    sequence.serif.x-windows-949=alphabetic,korean,dingbats,symbol
    sequence.sansserif.x-windows-949=alphabetic,korean,dingbats,symbol
    sequence.monospaced.x-windows-949=korean,alphabetic,dingbats,symbol
    sequence.dialog.x-windows-949=alphabetic,korean,dingbats,symbol
    sequence.dialoginput.x-windows-949=alphabetic,korean,dingbats,symbol
    
    sequence.allfonts.x-windows-874=alphabetic,thai,dingbats,symbol
    
    sequence.fallback=lucida,\
                      chinese-ms950,chinese-hkscs,chinese-ms936,chinese-gb18030,\
                      japanese,korean,devanagari,punjabi,gujurati,tamil,telegu,\
                      kannada,arialunicodems,chinese-gb18030-extb
    
    # Exclusion Ranges
    
    exclusion.alphabetic=0700-1e9f,1f00-20ab,20ad-f8ff
    exclusion.chinese-gb18030=0390-03d6,2200-22ef,2701-27be
    exclusion.hebrew=0041-005a,0060-007a,007f-00ff,20ac-20ac
    
    # Monospaced to Proportional width variant mapping
    # (Experimental private syntax)
    proportional.MS_Gothic=MS PGothic
    proportional.MS_Mincho=MS PMincho
    proportional.MingLiU=PMingLiU
    
    # Font File Names
    
    filename.Arial=ARIAL.TTF
    filename.Arial_Bold=ARIALBD.TTF
    filename.Arial_Italic=ARIALI.TTF
    filename.Arial_Bold_Italic=ARIALBI.TTF
    
    filename.Arial_Unicode_MS=ARIALUNI.TTF
    
    filename.Courier_New=COUR.TTF
    filename.Courier_New_Bold=COURBD.TTF
    filename.Courier_New_Italic=COURI.TTF
    filename.Courier_New_Bold_Italic=COURBI.TTF
    
    filename.Times_New_Roman=TIMES.TTF
    filename.Times_New_Roman_Bold=TIMESBD.TTF
    filename.Times_New_Roman_Italic=TIMESI.TTF
    filename.Times_New_Roman_Bold_Italic=TIMESBI.TTF
    
    filename.SimSun=SIMSUN.TTC
    filename.SimSun-18030=SIMSUN18030.TTC
    filename.SimSun-ExtB=SIMSUNB.TTF
    
    filename.MingLiU=MINGLIU.TTC
    filename.PMingLiU=MINGLIU.TTC
    filename.MingLiU_HKSCS=hkscsm3u.ttf
    
    filename.David=DAVID.TTF
    filename.David_Bold=DAVIDBD.TTF
    
    filename.MS_Mincho=MSMINCHO.TTC
    filename.MS_PMincho=MSMINCHO.TTC
    filename.MS_Gothic=MSGOTHIC.TTC
    filename.MS_PGothic=MSGOTHIC.TTC
    
    filename.Gulim=gulim.TTC
    filename.Batang=batang.TTC
    filename.GulimChe=gulim.TTC
    
    filename.Lucida_Sans_Regular=LucidaSansRegular.ttf
    filename.Mangal=MANGAL.TTF
    filename.Symbol=SYMBOL.TTF
    filename.Wingdings=WINGDING.TTF
    
    filename.Raavi=RAAVI.TTF
    filename.shrti=SHRTI.TTF
    filename.Latha=LATHA.TTF
    filename.Gautami=GAUTAMI.TTF
    filename.Tunga=TUNGA.TTF

    Where should I alter the settings above to solve the problem.

    Thank you in advanced.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Give some facts - details about your configuraiton that determine the way characters are strored in the database, and that determine how those characters are represented on screen.

    The "application code code" and the "database code page/code-set/territory/region-code" determine these things. But you don't give those details!


    What is your DB2 version and fixpack ?

    On your database, what is the database-territory, code page, code set, country/region code?

    What is your client computer operating system ? (Windows, Linux ) ?

    What is the LOCALE of your client operating system ?
    If your client-computer is Linux, this is determined by the value of the LANG environment variable.
    If your client-computer is Windows, this is determined by the regionial-settings and sysdem default locale.

Posting Permissions

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