Re: NLS_LANGUAGE and Java/JDBC

I think you need to set language set to UTF8. Check ...

select * from v$nls_parameters;

I don't know how to migrate the database from American/America to UTF8 in a easy way. The way I did it is to remove the database and recreated again using Database Configuration Assistant tool. And be careful when come to the point to select NLS.

Let me know if there is another way to do this without destroy the whole database.

• Herbert

In article <MPG.15ef24298f3778c8989ca5_at_news.ntua.gr>, Phivos says...
>
>(Sorry for the crosspost, but wasn't sure...)
>
>
>Do NLS parameters, such as NLS_LANGUAGE and NLS_TERRITORY, affect the way
>JDBC handles data from queries?
>
>
>
>My problem:
>I have iso-8859-7 data stored in an Oracle 8.1.7 on win2000. If I query
>some table from SQL*Plus I get *correct* results (guess has to do with
>the iso-8859-7 OS locale).
>
>But if I query through JDBC (from a JSP page using a Javabean) I get
>??????? instead of greek characters.
>
>My NLS_LANGUAGE, NLS_TERRITORY parameters are set to AMERICAN and
>AMERICA.
>
>Need to mention also that if i open DBAstudio and connect through the GUI
>to the Database, I DO NOT see correct data in the tables, but iso-8859-1
>(western european) characters!
>
>Hope didn't confuse you, any help appreciated.
>
>
>--
>__
>Never explain.
>Your friends will understand you.
>Your enemies will never believe you anyway.
>
>
Received on Tue Aug 28 2001 - 07:06:43 CEST