Subject | Re: [firebird-support] Changing database charset |
---|---|
Author | Alexandre Benson Smith |
Post date | 2006-11-15T00:04:46Z |
Fabiano Bonin wrote:
You could mess with system tables, but I dont think it's a good ideia.
Besides you need to inactivate/reactivate all the indices (wich is
impossible for FK and PK)
If I were you I would extract the metadata, change it, create an empty
database, and use IBPump to pump the data.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Is there some approach to change the charset of an existing table or database?Hi Fabiano,
>
> I'm using FB 2.0.
>
> Thanks
>
>
You could mess with system tables, but I dont think it's a good ideia.
Besides you need to inactivate/reactivate all the indices (wich is
impossible for FK and PK)
If I were you I would extract the metadata, change it, create an empty
database, and use IBPump to pump the data.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br