Chau Chee Yang wrote:

> I create my firebird database without specifing character set, so I
> assume it was created with character set none. My database already
> contain data. How can I alter my database's character set to UTF8?

Use isql -x or some other tool to extract metadata. Do a find&replace in
it to remove any references to NONE. Create a new database using the
changed script. Copy the data from old database using some tool like
FBCopy or IBDataPump.

http://www.firebirdfaq.org/fbcopy.php

Enjoy.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com