[firebird] Converting DB from one charset to other

[Jacek Laskowski 57]

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?

[Markus Kinzler 174]

Best by batchmoving the data from one db to another.

[Fr0sT.Brutal 900]

IB/FB has DataPump AFAIK

[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

[FredS 138]

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 ;

 

[c0d3r 17]

Here you go, this is how I did exactly what you wanted:

 

https://github.com/zedalaye/fbclone

[Guest]

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

 

hug