> >>2. Quoted identifiers should be (and are already) case sensitive and
> >>support national characters. What's new is here that all bugs in this
> >>area should be removed, in FB itself and in client tools etc. This would
> >>not break backwards compatibility - it would simply make life easier for
> >>those of us who want to use this new feature to its full extent.
> >
> > I'm not aware of any problems IN FB in this area.
>
> Might be true. I know I was unable to use Swedish letters åäö in my
> identifiers via any of the client tools I tried: Marathon, FlameRobin,
> IB_SQL, ... Don't remember the details though.

I just tried with Database Workbench. It identifies the special characters,
uses quoted identifiers (dialect 3) and is able to create tables browse
them and insert data...

:-)

RECREATE TABLE "I_TABLE_ÅÄÖ"
(
"ÅÄÖ" INTEGER
);

/*
"I_TABLE_ÅÄÖ"
-------------
Exporting all rows
*/
INSERT INTO "I_TABLE_ÅÄÖ"("ÅÄÖ") VALUES (1);
INSERT INTO "I_TABLE_ÅÄÖ"("ÅÄÖ") VALUES (2);
/* 2 row(s) exported */



With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com