Devart Forums

Hello,

I'm trying to insert/read some data in unicode format. When I store chars like "ä", "ö" etc. in VarChar-Fields, all is working fine.

But when I store the same data in a blob-field, the will be stored as "????".

I create a database with default character set utf8, and also created the blobs with utf8.

Blob = Subtype text, segment size 80, collate/charset: utf8
Varchar = 100 (chars), utf8

What could be the problem? Before I connect, I set the following options:

Connection.SpecificOptions.Values['Charset'] := 'UTF8';
Connection.SpecificOptions.Values['UseUnicode']:='True';
Connection.SpecificOptions.Values['EnableMemos']:='True';

Can you please post me a demo-code, showing how to insert an utf8-string into a blob-field? I use parameters while inserting/updating.

Thanks in advance.

Hello.
Please specify the Delphi version you are using.

Please let me know if the problem was solved.