Subject Re: [firebird-support] Storing Delphi 2009 "UnicodeString" into database, UTF8?
Author Martijn Tonies
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?

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