Re: Help - Multi Language in Oracle

This probably is because chinese characters are doubly bytes and normal ones are just one. We had the luck our programming language took over the conversion.

Sorry, but if you know any solution on Oracle niveau pls let me know minicooper_at_quadrat.be

"Leah Weston" <leah_at_angel.net> wrote in message news:85d2o5$bte$1_at_nnrp1.deja.com...
> I have Oracle tables set up in UNICODE which are being used to build
multiple
> international sites in multiple languages. This works fine until we start
to
> work with Japanese. I'm assuming the Oracle client will handle translation
> from Shift-JIS to UNICODE and back if I can set the right environmental
> variables at the right time. The tables are populated by PHP scripts which
> I'm reasonably convinced are doing their job properly but somewhere in the
> process, my data turns to garbage.
>
> Can anyone give me a rundown of pitfalls and environmental variables I
should
> set to pull off this operation?
>
> currently I do this before the logon:
>
> putenv("ORA_NLS32=/dbs900/product/8.0.5.0.1/ocommom/nls/admin/data");
> putenv("NLS_LANG=JAPANESE_JAPAN.JA16SJIS");
> putenv("LANGUAGE=JAPANESE");
>
> Are there other variables I should be setting or perhaps a different time
to
> set them?
>
> Any clues would be greatly appreciated.
>
> Th
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 11 2000 - 01:57:16 CST