Hello Stefan,

>
>>> I'm developing an application that needs to store Delphi 2009
>>> UnicodeString, would Firebird UTF8 be OK for that?
>>
>> the new Delphi 2009 UnicodeString type is UTF-16. You can convert that
>> to UTF-8 and back without loss. AFAIK Firebird doesn't work with any
>> 16-Bit string types, so you'll have to convert everything before
>> storing it in the database (or your Client library does it; if it's
>> IBO I'm not sure how good it is with that :-(
>
> How does one go about in storing UTF16 in Firebird? So that no conversion
> is required?

Never mind that, duh, our own dbExpress driver seems to handle this.

From Delphi 2009, I'm getting "WideChar" into the driver, is that sufficient
to sture UnicodeString.

I'm having trouble to find this stuff in the Delphi Help :-/

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com