Storing UTF8-CLOB in UTF8 Database?

[Frank Kintrup]

Hi,

I have a seemingly trivial problem, but the solution eludes me so far...

Delphi 2010, Oracle 10g (UTF8), DOA 4.1.2

I have a PAnsiChar buffer containing UTF8 data. With Delphi 2007 I just used

oLOBLocator.Write(pBuffer^, iWrite);

to write the contents to the database. With Delphi 2010 and 4.1.2 this no longer works, the result stored in the database is garbage. Using a hex dump of the stored data I see that the stored *bytes* itself are correct, but the database interpreted every two of them as one unicode character, which does not work very well on XML data ;-)

Is there a way to force DOA to accept the data as UTF8 or do I have to convert it to a wide string first?

Frank

 

[Marco Kalter]

Is this a CLOB or a BLOB?

 

[Frank Kintrup]

The database field is a CLOB.

 

[Marco Kalter]

CLOB's can only hold UTF16 data. It's an Oracle Server restriction. To store UTF8 characters, you would need to use a BLOB instead.