Currently, our database uses Win1252 as the only character encoding. We will have to support Unicode in the database tables soon, which means we have to perform this migration for four databases and around 80 Delphi applications which run in-house in a 24/7 environment. Are there recommendations for database migrations to UTF-8 (or UNICODE_FSS) for Delphi applications? Some questions listed below. Many thanks in advance for your answers!
- are there tools which help with the migration of the existing databases (sizes between 250 MB and 2 GB, no Blob fields), by dumping the data, recreating the database with UNICODE_FSS or UTF-8, and loading the data back?
- are there known problems with Delphi 2009, dbExpress and Interbase 7.5 related to Unicode character sets?
- would you recommend to upgrade the databases to Interbase 2009 first? (This upgrade is planned but does not have a high priority)
- can we simply migrate the database and Delphi will handle the Unicode character sets automatically, or will we have to change all character field types in every Datamodule (dfm and source code) too?
- which strategy would you recommend to work on the migration in parallel with the normal development and maintenance of the existing application? The application runs in-house so development and database administration is done internally.
Update: From InterBase discussion forum thread: Unicode Databases in InterBase - Really? (it is not a thread by me but it shows that some problems still exist in InterBase XE).
Here are some reports I've submitted:
QC#92867 - String fields are blank
coming from Views only if the View
includes a Union, and when using a
ClientDataSet. This was found as
missing data on a few of my reports,
which no longer work.
QC#91494 - IB Character column data
Character fields (eg: Char(1)) are
padded with blanks when retrieved
through a stored procedure. Tests fail
- eg: If Active = "Y". I make heavy use of stored procedures with forms
and these do not work.
QC#91355 - IBSqlMonitor fails. The
output of IBSqlMonitor is somewhat
garbled making this tool useless. (So,
even my shovel is broken!)
Unreported - Persistent fields in
TClientDataSet fail for TWideString.
Other related QC entries:
QC#94455 SQL Unicode Char Type Failure (InterBase XE)
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
