Hi,

With Delphi, I'm trying to insert characters into a UTF8 column
in Firebird 2.

If I'm trying to insert a string 'test', it works fine:

(IBO)
FCommand.Params[Index].AsString := 'test';

But as soon as more special characters are used:
FCommand.Params[Index].AsString := 'tesét';

Firebird raises a "malformed string" error.

I've tried WideString instead of String, but that inserts the first char
only, so that seems way off.


Anyone got a clue?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com