Hi

We are finally embarking on moving from D2007 to XE2. I have done some
reading with regards to the issues involved in the process and am
(overly) confidant :)

However I just need to get my head around Firebird / IBO issues. Any
comments or suggestions around the below would be great...


1) The new String in EX2 is Unicode (UTF16), is the .AsString parameter
now UTF16?
2) If the underlying database fields are defined as UTF8 does the
.AsString automatically handle the conversion between formats?
2a) Do I need to make settings changes in the component to
allow for this?
2c) Do I need to 'tell' IBO where a field is defined as UTF8?

3) If the underlying DB fields are 'Undefined' data type, what format
does .AsString save the data as?

Currently our database characterset is not specified. We are porting to
XE2 and don't immediately want full Unicode support. There are however a
couple of areas, names and addresses, where we plan to change the
underlying fields to UTF8. Our databases are already full of text that
is in Ansi string format and our plan is / was to leave most fields as
undefined and just specify the ones we plan to store UTF8 in.

4) I note there is a ib_connection.CharSet property that I could set to
'UTF8'. However if I have mixed character sets defined for my database
this will be a problem (I assume).

5) Would I be best just to set the default character set to UTF8 and be
done with it? I have read there might be performance and database size
issues?

6) If I build a new empty DB with UTF8 set as the default char format
and I use the IB_DataPump to copy data frorm an old unspecified
character set database will my data copy across as UTF8 (Assuming I set
the CharSet for the destination DB to UTF8 and leave the source database
unset (as it currently is)?

7) Is there an easy way to detect the character set of the source
database so that the pump process correctly identifies the source DB
character set where the source DB is already converted to UTF8?

Thanks
Rob