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.