[jboss-user] [JBoss Tools (users)] - Re: NLS problem with oracle 8

[snjeza]

You need to check which character set your database uses.
In order to check this you can call:

select NLS_LANGUAGE,NLS_TERRITORY,NLS_CHARACTERSET from nls_database_parameters

from sqlplus, for instance

Then, set the NLS_LANG variable using
-DNLS_LANG=<NLS_LANGUAGE>_<NLS_TERRITORY>.<NLS_CHARACTERSET>
for instance:
-DNLS_LANG=SPANISH_SPAIN.WE8ISO8859P1

If the database is created by the default nls_lang (AMERICAN_AMERICA.WE8ISO8859P1), you can use:
-Duser.language=en_US

I suppose your Oracle 10g database is created with the UTF-8 character set.




View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4229807#4229807

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4229807