NLS_LANGUAGE and Java/JDBC
Date: Thu, 23 Aug 2001 15:31:37 +0300
Message-ID: <MPG.15ef24298f3778c8989ca5_at_news.ntua.gr>
(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:
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
Hope didn't confuse you, any help appreciated.
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).
(western european) characters!
--
__
Never explain.
Your friends will understand you.
Your enemies will never believe you anyway.
Received on Thu Aug 23 2001 - 14:31:37 CEST