Hmmmm... Seems that the discussion with Kjell
would ended in what William Shakespear in his
wisdom called "Much Ado about nothing"...

On Wed, 23 Mar 2005 11:49:06 +0100, Martijn Tonies wrote:

>
>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
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>