Hello Kjell,

> > 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 */
>
> That's nice. Does it work with:
>
> 1. Indices?

Created an index from the Index Editor:
CREATE ASC INDEX "I_I_TABLE_ÅÄÖ_" ON "I_TABLE_ÅÄÖ" ("ÅÄÖ");

> 2. Constraints?

Constraint:
ALTER TABLE "I_TABLE_ÅÄÖ" ADD PRIMARY KEY
("ÅÄÖID");

> 3. Lower-case/mixed-case (in all places)?

What do you mean by this?

I had "lower case" turned OFF for the editors.

Anyway, if you're using mixed case, Database Workbench will automatically
quote the identifiers in the editors or generated SQL statements.

With regards,

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