Subject How to convert to one charset to another
Author Loris Luise
Post date 2014-05-20T08:09:01Z
Hello,

I need your help and suggestions to solve a (maybe uncommon) task.

I searched a lot on the web, I had some success using a tool called fbclone but
this is definitely not a solution (due to extreme slowness)

I have a large Firebird 2.5 DB (a couple of tables have few millions records) to convert from WIN1251 charset to UTF8 charset.

Is there a way to do efficiently this kind of conversion? (preferable not using a intermediate text sql dump, that would not applicable because the size of the DB).

I'm using Firebird on a linux machine, and I really like to do the job using a bash script,
but I can fallback also using a remote Windows pc.

Thanks for any suggestions.

Best regards.


--
------------------------------------

Nota di riservatezza : Il presente messaggio, corredato dei relativi
allegati, contiene informazioni da considerarsi strettamente riservate, ed
è destinato esclusivamente al destinatario sopra indicato, il quale è
l'unico autorizzato ad usarlo, copiarlo e, sotto la propria responsabilità,
diffonderlo. Chiunque ricevesse questo messaggio per errore o comunque lo
leggesse senza esserne legittimato è avvertito che trattenerlo, copiarlo,
divulgarlo, distribuirlo a persone diverse dal destinatario è severamente
proibito, ed è pregato di rinviarlo immediatamente al mittente
distruggendone l'originale. Grazie.

Confidentiality Notice : This message, together with its annexes, contains
information to be deemed strictly confidential and is destined only to the
addressee(s) identified above who only may use, copy and, under his/their
responsibility, further disseminate it. If anyone received this message by
mistake or reads it without entitlement is forewarned that keeping,
copying, disseminating or distributing this message to persons other than
the addressee(s) is strictly forbidden and is asked to transmit it
immediately to the sender and to erase the original message received. Thank
you.