Oracle 7 + JDBC + Unicode strings

From: <andrew.smallbone_at_reuters.com>
Date: Fri, 19 Jun 1998 19:09:28 GMT
Message-ID: <6med17$5lf$1@nnrp1.dejanews.com>

I want to store Java unicode strings in an Oracle 7 database with JDBC 7.3.4.
The thin driver appears to be detecting that I'm sending characters that aren't in my db character set and replaces them with '?'. The thick driver somehow messes them up completely.

When I installed oracle or created the database I set the character set to Western European. Should I have set this to UTF-8? Is it possible to change?

Any help appreciated.

On another point has anyone noticed that the thin driver can't insert data into a long column that's bigger than about 2-3K?

Thanks
Andrew

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 19 1998 - 14:09:28 CDT