Re: JDeveloper9i non-English character problem

killjoy_tr_at_yahoo.com (killjoy) wrote in news:503a497a.0204110530.78f0958c_at_posting.google.com:
> I've downloaded and started to use jDeveloper9i on W2K. I'm also
> running personal oracle9i on the same machine. To avoid Turkish
> character confusion in JDeveloper9i, I needed to set the locale to
> English (U.S.). This way, didn't found any problem with
> JDeveloper9i. However, in database I can't use Turkish characters
> due to the change made in regianal setting locale.
>
> Is there any body faced such a problem on using non-English
> characters with both JDeveloper9i and Oracle9i database? Is there
> anything I can try?

Make sure you use NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 in the environment for both products. This can be set in the registry (ORACLE key) and in the environment prior to starting the products. If this helps depends on the character set in which you created the database. You should also check the database parameters themselves to prevent charset conversion ( enter 'show parameter nls' in SQL*Plus).

Even though JDeveloper 9i is still Release Candidate you should not have these problems - they are related to incorrect environment settings.

You could see the National Language Support Guide on http://otn.oracle.com for details.

• Sander