> I think it is related to using a UTF8 database with UTF8 character set
> at connect time, but without a unicode capable client tool.
>
> What happens, specifying e.g. ISO8859_1 or WIN1252 at connect time, even
> if it is a UTF8 database?
>
> I once switched back from UTF8 to ISO8859_1 for a newly created Firebird
> 2.1 cause of these problems.

Additionally, but probably obviously, this still fails:

select
*
from
"ÅÄÖ"

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com