Re: storing Japanese characters

I tried with some other input values and as you suspected I saw a lot more $B??(B's. I did a block dump and the database is definitely not storing things in UTF8 internally. I am sure this has more to do with my database configuration than anything, but thanks for the reply. I'll post the solution for everyone's reading pleasure when I figure out what's happening.

John

Jim Breen wrote:

> 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

--
Liquid Audio Inc.
John Pink -- Database Administrator
voice (650) 549-2142
fax (650) 549-2099 Received on Wed Nov 24 1999 - 18:55:33 CST