Hi,

> How do I get rid of double quotes. I have greated a database and
> tables with IBOConsole (dialect 3 characterset 8891-1 collation FI_FI)
> and now I have to add double quotes around table names, field names
> and whatever. Also table names are case sensitive.
>
> I have been working a lot with Oracle, Sybase, MS etc. and get used
> to use double quotes only in special cases.

If you create your objects like "TABLENAME", they aren't
case sensitive.

eg:

CREATE TABLE MyTable
can be used as:
MyTable - MYTaBLE - "MYTABLE"

CREATE TABLE "MyTable"
can be used as:
"MyTable" only

CREATE TABLE "MYTABLE"
can be used as:
MyTable - MYTaBLE - "MYTABLE"

Almost all more pro GUI tools allow you to set their GUI
to automatically uppercase everything you create when using
the object editors. Ours does as well.

With regards,

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