| Цитата |
Thin JDBC
---------
a JDBC Thin driver ("jdbc:oracle:thin:@.....") is not using the NLS_LANG.
The Oracle Thin driver supports the following character sets
trough basic zip/jar files (classes111.zip, classes111.jar,
classes12.zip and classes12.jar, ojdbc14.jar) they contain all the
necessary classes to provide complete NLS support for:
- Oracle Character sets for CHAR/VARCHAR/LONGVARCHAR/CLOB type data
that is not retrieved or inserted as a data member of an Oracle 8
Object or Collection type.
- NLS support for CHAR/VARCHAR data members of Objects and
Collections for a few commonly used character sets. These
character sets are: US7ASCII, WE8DEC, WE8ISO8859P1 and UTF8.
If your database use a other character set (WE8ISO8859P15,WE8MSWIN1252, EE8MSWIN1250,...)
you must include nls_charsetxx.zip/nls_charsetxx.jar in your CLASSPATH.
If this file is not in your CLASSPATH, you will see the following exception:
java.sql.SQLException: Non supported character set: oracle-character-set-178
when connecting to a WE8MSWIN1252 database.
The "oracle-character-set-178" may be different depending on the characterset
of the database you try to connect to.
Connecting to a WE8ISO8859P15 db will return "oracle-character-set-46" for example.
Please do not try to put multiple versions of the Oracle JDBC drivers
in your CLASSPATH.
On Windows clients:
- Add [ORACLE_HOME]\jdbc\lib\classes111.zip and
[ORACLE_HOME]\jdbc\lib\nls_charset11.zip to your CLASSPATH.
(Add classes12.zip and nls_charset12.zip if JDK 1.2.x or 1.3 is
used. Add ojdbc14.jar and nls_charset12.zip if JDK 1.4 is used.)
- Make sure [ORACLE_HOME]\bin is in your PATH.
see the Readme.txt in [ORACLE_HOME]\jdbc for more information
|
|