the problem is not case sensetive or case insensetive
the problem is storing object name as UPPERCASE and not AS IS

SOIGETUNREADABLENAMESWHILEMIGRATINGTOFIREBIRDFROMMYSQL

>stay case-insensitive but become case-preserving

That is the thing what I have asking

----- Original Message -----
From: Magnus Titho
To: firebird-support@yahoogroups.com
Sent: Tuesday, December 04, 2007 6:16 PM
Subject: Re: [firebird-support] Upper case behaviour


Eugen.Konkov@... wrote:
> I ask only to match 'myTable' and 'fieldID' when I query it by
> select fieldID from myTable
>
> and when table chema is:
> create table "myTable" (
> "fieldID" integer
> );
>
Your problem is that you create the table case-sensitive (quoted
tablename), but your select doesn't use quotes and so is not case-sensitive.

--
Magnus





[Non-text portions of this message have been removed]