Subject | Re: [firebird-support] Changing database default character set |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-01-31T21:50:38Z |
> I'm migrating from Firebird 2.0 to Firebird 2.5 ( both on DebianNo, sorry.
> Linux )
> My databases were created with default character set NONE.
> ¿ Is there a way to change this default when restoring ?
Re-create the database via DDLs with the new character set and then use
a tool to transfer the data. Depending on the targeted character set
(especially multi-byte CS), you might run into issues when e.g. longish
[VAR]CHAR fields are indexed.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/