Reading French characters (é, è, à, ...) in a CLOB field

mtawk · Post by **mtawk** » Wed 04 May 2005 16:05

hello,
I have a problem in reading special characters (Specially French characters) from CLOB fields.

I have found a way to read other field types (varchar,...) by setting the charset to the connection :

Connection.Options.Charset = 'WE8ISO8859P1'

But unfortunately, it doesn't work with reading CLOB fields type.

I would appreciate any help to slove this problem

Alex · Post by **Alex** » Thu 05 May 2005 12:02

Please specify your exeact ODAC and Oracle version, also try to use unicode support (set TOraSession.Options.UseUnicode to true).

mtawk · Post by **mtawk** » Thu 05 May 2005 14:04

Actually, I'm using ODAC 5.50 + Oracle10g + Linux RedHat 3.0 with Delphi-Kylix.

I have tried using unicode, but I had a problem when reading big XML text from a CLOB field, coz I'm getting a scrumbled XML as a result.