Re: Kanji Support

Richard wrote:

> Andreas,
>
> You can have two character sets in an Oracle database. The database
> character set defines the characters that can go in to CHAR and VARCHAR type
> fields and the national character set defines the characters that can go in
> NCHAR and NVARCHAR type fields.
>
> If you have the database set to a Western European character set then you
> can't put Kanji characters into CHAR or VARCHAR. You could set the national
> character set to a Unicode character set then you could put Kanji into NCHAR
> and NVARCHAR fields.
>
> If you want to use the context server to search LOB fields, this won't work
> and you will have to set the main database character set to a Unicode font.
> Context server cant search NCLOB fields.
>
> Please send me an email if I can be of any further assistance. You can
> email me in German if this would be more convenient for you.
>
> Best Wishes,
>
> Richard
>
> "Andreas Proeglhoef" <andreas.proeglhoef_at_aim-sw.com> wrote in message
> news:nxG9a.55490$AV5.690812_at_news.chello.at...
> > Hi Daniel thanks for reply
> >
> > We are using a Database which is in English.
> > The question is: Is it possible that fill in existing tables rows (
> fields )
> > where the values are in kanji fonts ?
> >
> > Excample
> >
> > Row 1 Meta 1 EN Meta 2 GR Meta 3 JP
> > 1 True WAHR Japan True
> > 0 False FALSCH Japan False
> > 5 Next NÄCHSTER Japan Next
> >
> >
> > The Meta 3 Row should hold the Metadata in the Kanji font.
> >
> > THX
> >
> > Andi
> >
> > "DA Morgan" <damorgan_at_exesolutions.com> schrieb im Newsbeitrag
> > news:3E6381D2.3DFE4021_at_exesolutions.com...
> > > Andreas Proeglhoef wrote:
> > >
> > > > Does anyone knows ho to use metadata in a english database with kanji
> > values
> > > > or fonts.
> > > > Or can anyone send me a link to to relevant sites
> > > >
> > > > THX
> > >
> > > What you are asking is not clear.
> > >
> > > Please be sure to include Oracle version, edition, and the databases
> > character
> > > set and NLS parameters.
> > >
> > > Daniel Morgan
> > >
> >
> >

But if you intend to store multiple character sets in a single database. Then create your database with UTF8 and then you can store anything anywhere you wish.

Just remember when working with Kanji or other multibyte character sets ... VARCHAR2(10) means 10 bytes, not 10 characters. And that SUBSTR and be sure when choosing functions to consider whether what you are asking for is bytes or characters..

Daniel Morgan Received on Thu Mar 06 2003 - 10:23:48 CST