Martijn Tonies wrote:

>>2. Constraints?
>
> Constraint:
> ALTER TABLE "I_TABLE_ÅÄÖ" ADD PRIMARY KEY
> ("ÅÄÖID");

Ah, but how about this:
ALTER TABLE "I_TABLE_ÅÄÖ" ADD PRIMARY KEY "ÅÄÖ_PK" ("ÅÄÖID")

>>3. Lower-case/mixed-case (in all places)?
>
> What do you mean by this?

I meant, does it work even if I want to name my
table/field/index/constraint "MinLåda" (= "MyBox" in English)? I think I
had problems only with lower-case åäö in one of the tools I tested.
Hence the question.

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

Sounds good, as usual. :-) When we start making money we might just
inves in your tool as well as your FB driver, although we'd like to stay
on ADO since we also use MSSQL.

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64