>是否有工具可以通过转储数据,使用UNICODE_FSS或UTF-8重新创建数据库以及加载数据来帮助迁移现有数据库(大小在250 MB到2 GB之间,没有Blob字段)?
> Delphi 2009,dbExpress和Interbase 7.5是否存在与Unicode字符集相关的已知问题?
>您会建议先将数据库升级到Interbase 2009吗? (此升级已计划但不具有高优先级)
>我们可以简单地迁移数据库,Delphi会自动处理Unicode字符集,还是我们必须更改每个Datamodule(dfm和源代码)中的所有字符字段类型?
>您建议在正常开发和维护现有应用程序的同时进行迁移的策略是什么?该应用程序在内部运行,因此开发和数据库管理在内部完成.
更新:来自InterBase论坛帖子:Unicode Databases in InterBase – Really?(它不是我的一个帖子,但它表明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.07001 – 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.07002 – 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.
其他相关的QC条目: