majstor wrote:

> I have large Firebird database about 20GB is database file. I need to convert that database from UNICODE_FSS to UTF8!
> Is there any solution (step by step if it is possible) how to convert this database???

Here's how I do it:

isql -x database.fdb | sed "s/UNICODE_FSS/UTF-8/" > new.sql
isql
SQL> create database 'newdb.fdb' default character set UTF-8;
SQL> input new.sql;
SQL> exit;

fbcopy s database.fdb newdb.fdb

:)


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================