Subject | Re: Using unicode versus WIN1252 (Firebird 2) |
---|---|
Author | josef_gschwendtner |
Post date | 2009-01-09T15:07:55Z |
> Main issue is the storage size of Unicode and UTF8. Since morebytes are
> used per character, this means that you can have less characters inthat
> char/varchar fields, procedure parameter, indexes and for
> sorting/grouping operations. Consequently, some of your queries
> work with WIN1252 might fail with UTF8.German characters mostly have ASCII < 7F. With UTF8 these characters
have the same storage size as in WIN1252, right?
Therefore a new database with default character set UTF8 should have
about the same size as the old WIN1252 database, right?
Isn't it correct that a field/parameter with varchar(50) always has
room for 50 characters (albeit some characters need more then one
byte)?
> Creating a new database and copying the data is as easy as:With this methode the new database has the same character set as the
>
> gbak -b -m database.fdb database.fbk
> gbak -c database.fbk new_database.fdb
> fbcopy se database.fdb new_database.fdb
old one, right?
What would be best practice to get a new database with a different
default character set (UTF8)?