Subject | Re: [firebird-support] Use of double quoted names in Firebird |
---|---|
Author | Kjell Rilbe |
Post date | 2005-03-23T10:38:06Z |
Martijn Tonies wrote:
1. Indices?
2. Constraints?
3. Lower-case/mixed-case (in all places)?
Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> I just tried with Database Workbench. It identifies the special characters,That's nice. Does it work with:
> 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 */
1. Indices?
2. Constraints?
3. Lower-case/mixed-case (in all places)?
Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64