Am 31.03.2010 19:33, Sasa Mihajlovic wrote:
> I have one of my business application which is use firebird as
> backgroung application and unicode_fss as collation. I have a lot of
> problems with unicode and firebird and I would like to create new empty
> database with utf8 collation and made application in delphi which will
> read data from one (unicode) database and convert all data to utf8
> string and save it to new blank database with utf8 collation.
> I need procedure which will read all unicode strings and convert it to
> utf8 character set with all latin letters?
> Thanks in advanced...
instead of writing it yourself could use a tool like Database Workbench
or IBExpert to dump the database and re-create it with the new character
Both Database Workbench and IBExpert can do the data migration for you.
betasoft - Software for Delphi™ and for the Java™ platform
http://www.mikejustin.com - http://www.betabeans.de