Devart Forums

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

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

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.