Re: Kanji Support

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
> >
>
>
Received on Thu Mar 06 2003 - 09:38:31 CST