Jump to content
Jacek Laskowski

[firebird] Converting DB from one charset to other

Recommended Posts

Is it possible to automatically convert the entire Firebird database from win-1250 to UTF-8 encoding? Are there any tools for this purpose? Or using backup/restore?

Share this post


Link to post
Guest

Ask in FB news/support groups/areas. This is not the correct forum.

There is a "cultural affinity" between Delphi and FB/IB. But that's it.

 

Anyhow, yes, there are both instructions and specific scripts in FB installs to lever that problem.

Considering the deployment it is either a "breeze" or "process".

 

/D

Share this post


Link to post
10 hours ago, Jacek Laskowski said:

entire Firebird database from win-1250 to UTF-8 encoding?

Assuming you have no 'explicit COLLATE ' in your tables you can use ALTER CHARACTER SET on an empty DB and batch move data into that.

 

Or add this to your creation statement, keep in mind there where speed issues with UNICODE_CI_AI until v3.07:

CREATE DATABASE :FileName
USER :UserName PASSWORD :Pwd
PAGE_SIZE 16384
default character set UTF8 collation UNICODE_CI_AI ;

 

Share this post


Link to post
Guest

remember: there a dialect 1 between changes, then, any chars not founded in another set, can dont be showed as expected.

 

hug

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×