Re: storing Japanese characters

From: Jim Breen <jwb_at_nexus.csse.monash.edu.au>
Date: 22 Nov 1999 22:57:13 GMT
Message-ID: <81cho9$1j3$1@towncrier.cc.monash.edu.au>

In sci.lang.japan John R. Pink <jpink_at_liquidaudio.com> wrote:
>>I am trying to insert Japanese characters into my Oracle 8.0.5 database
[snip]
>>when I query (select * from test;) I get:

>>$B??(B , $B??(B

>>which is JIS code: 3F3F Kuten: 3131 Shift-JIS: 905e Unicode: 771f octal
>>\277\277

That JIS of "3F3F" looks *very* suspicious. Possibly something is turning "bad" characters into partial ASCII nulls. I have looked at the UTF8 coding of $B1`(B and $B??(B and I can't see a relationship.

I suggest you try again with a different input character, and see if you get the same output. One way or the other it may provide useful evidence. --
Jim Breen [j.breen@csse.monash.edu.au http://www.csse.monash.edu.au/~jwb/]

Computer Science & Software Engineering,                Tel: +61 3 9905 3298
Monash University,                                      Fax: +61 3 9905 3574
Clayton VIC 3168, Australia      $B%8%`!&%V%j!<%s(B@$B%b%J%7%eBg3X(B

Received on Mon Nov 22 1999 - 16:57:13 CST