Re: inserting non-english strings into oracle table

And remember about creating a database with proper charset

Robert

"Christopher M. Day" wrote:

> Erwan,
>
> Sounds like you need UNICODE support within Oracle8.
>
> The character set you are looking for is JA16SJIS, so setting of the nls
> character set to JA16SJIS should work.
>
> Erwan Layman wrote:
> >
> > Hello,
> >
> > I am doing a project for a Japanese client using Oracle. I need to
> > select and insert Japanese Shift-JIS character-encoded strings into a
> > table column (of type varchar2). the problem is, the insert statement
> > will convert the string previously encoded in Shift-JIS into ASCII. I am
> >
> > using an English version of Oracle.
> >
> > My questions are:
> > 1. Do I need to set an NLS option to handle character encoding like
> > Shift-JIS? If so, how do I do that? If you have the exact NLS command,
> > it would be great.
> >
> > 2. If I dont use NLS, is there a function which would allow me to insert
> >
> > the original hex values of a string? So, my insert statement would look
> > something like, "insert into tablename values ('0xc2 0x83 0x7e')". This
> > would essentially allow me to store my encoded character "as is" into
> > the table.
> >
> > Thanks in advance. :o)

--

Robert Liziniewicz                    C.I. HTS-ComArch
Robert.Liziniewicz_at_ci.comarch.pl      ul. Ujastek 10, Krakow
                                      tel. (+48 12) 644-66-31
                                           (+48 601) 47-86-81