Ask for guide for saving multilingual character in Derby

[Crest.Boy]

Hi Guys: I am one new comer for derby. I tried many times but failed in saving multilingual characters in Derby. I get ? when I want to save Chinese characters. Who can provide one simple guide to save multilingual characters in Derby? It is better to show me step by step. Thanks a lot in advance!

[Rick Hillegas-2]

Crest.Boy wrote:

> Hi Guys: I am one new comer for derby. I tried many times but failed
> in saving multilingual characters in Derby. I get ? when I want to
> save Chinese characters. Who can provide one simple guide to save
> multilingual characters in Derby? It is better to show me step by
> step. Thanks a lot in advance!
> View this message in context: Ask for guide for saving multilingual
> character in Derby
> <http://www.nabble.com/Ask-for-guide-for-saving-multilingual-character-in-Derby-tp23800505p23800505.html>
> Sent from the Apache Derby Users mailing list archive
> <http://www.nabble.com/Apache-Derby-Users-f93.html> at Nabble.com.

Hello,

Derby's character datatypes are represented internally as Java strings.
That means that they are sequences of 2-byte unicode characters and are
therefore multilingual. If you insert character data into a Derby column
and select it later, you will retrieve from the database exactly what
you put into it.

It is hard to say anything more without knowing what experiments are
failing for you. We could probably give you some more advice if you
could share more information about those experiments.

Thanks,
-Rick

[Myrna van Lunteren]

On Sun, May 31, 2009 at 12:17 AM, Crest.Boy <wsxwinter@...> wrote:
> Hi Guys: I am one new comer for derby. I tried many times but failed in
> saving multilingual characters in Derby. I get ? when I want to save Chinese
> characters. Who can provide one simple guide to save multilingual characters
> in Derby? It is better to show me step by step. Thanks a lot in advance!
> ________________________________
> View this message in context: Ask for guide for saving multilingual
> character in Derby
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>

Sorry - I can't do a step-by-step right now, but the ? characters are
most likely what your console encoding shows, that is, the encoding,
or rather, codepage setting, set on the machine on which you try to
display the characters you retrieve after storing.
Did you insert the Chinese characters using unicode?

Are you on a Chinese machine? Windows? Linux?

Try issuing chcp on the command line, and see what you get, then look
around on the web and find a suitable chinese encoding.

If this doesn't help, I'll try more later, or maybe someone else will
put in their 2c.

Myrna

[Crest.Boy]

Yes, I do agree with you. It should be caused by code-page. I tried, it works now. Thanks a lot.

Myrna van Lunteren wrote:

On Sun, May 31, 2009 at 12:17 AM, Crest.Boy <[e-mail]> wrote:
> Hi Guys: I am one new comer for derby. I tried many times but failed in
> saving multilingual characters in Derby. I get ? when I want to save Chinese
> characters. Who can provide one simple guide to save multilingual characters
> in Derby? It is better to show me step by step. Thanks a lot in advance!
> ________________________________
> View this message in context: Ask for guide for saving multilingual
> character in Derby
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>

Sorry - I can't do a step-by-step right now, but the ? characters are
most likely what your console encoding shows, that is, the encoding,
or rather, codepage setting, set on the machine on which you try to
display the characters you retrieve after storing.
Did you insert the Chinese characters using unicode?

Are you on a Chinese machine? Windows? Linux?

Try issuing chcp on the command line, and see what you get, then look
around on the web and find a suitable chinese encoding.

If this doesn't help, I'll try more later, or maybe someone else will
put in their 2c.

Myrna