oracle jdbc and german umlauts 
Author Message
 oracle jdbc and german umlauts

hello,

we have got the following problem:

we have got a table in a oracle8i database with a varchar2(3) column.
when we try to stored three german umlauts (e.g. '???'), oracle error
'ORA-01401: inserted value too large for column' occurs. the problem
seems to be, that the umlauts are stored as two bytes. exactly the
same happens, when we use sqlplus and 'NLS_LANG' is set to
'GERMAN_GERMANY.WE8ISO8859P1' but it works perfectly when we set
'NLS_LANG' to 'GERMAN_GERMANY.UTF8'.

does anybody now how to tell the jdbc driver to use UTF8?

many thanks in advance!
michael volz



Sun, 27 Jun 2004 00:17:31 GMT
 oracle jdbc and german umlauts

Hi Michael,

for DB2 there are driver properties, you can use as extension to the url at
connecting time

Dieter

Quote:

> hello,

> we have got the following problem:

> we have got a table in a oracle8i database with a varchar2(3) column.
> when we try to stored three german umlauts (e.g. '???'), oracle error
> 'ORA-01401: inserted value too large for column' occurs. the problem
> seems to be, that the umlauts are stored as two bytes. exactly the
> same happens, when we use sqlplus and 'NLS_LANG' is set to
> 'GERMAN_GERMANY.WE8ISO8859P1' but it works perfectly when we set
> 'NLS_LANG' to 'GERMAN_GERMANY.UTF8'.

> does anybody now how to tell the jdbc driver to use UTF8?

> many thanks in advance!
> michael volz



Sun, 27 Jun 2004 01:50:28 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Troubles using German Umlauts with JDBC

2. DTS Import, German Umlaut, ignor some characters

3. german umlaut signs false representation after read from SQL2000 database

4. lower does not handle german umlaut

5. oas+jservlets and german umlauts

6. German umlauts

7. WebDB: German umlauts problem

8. german umlauts in SQL*plus/Windows w/ WE8PC850 charset

9. German Umlauts and ISQL

10. INFORMIX and german "umlaut"

11. ODBC, SQL and german umlauts

12. sort/select discrepancy with umlaut Oracle 7


 
Powered by phpBB® Forum Software