[frankge973]

I have Firebird v. 2.1.3 and a Database with Character Set = NONE
I've seend that all queries are Case Sensitive, in which way I can transofrm the DB to Case Insensitive?
I've seen that there isn't UTF8 char set or others.... How can change collation without recreating DB?
Thanks.

[clivew]

I can not imagine a situation in which I would want an entire database to be case insensitive.
Make your "appropriate" searches insensitive by uppercasing the column and the value in your SQL.

Clive

[frankge973]

No, in MSSQL it's possible. In which way I can change the collation on an already build FB DB? I cannot modify all queries in the code....

Originally Posted by clivew

I can not imagine a situation in which I would want an entire database to be case insensitive.
Make your "appropriate" searches insensitive by uppercasing the column and the value in your SQL.

Clive

[clivew]

FYI: I did not say it was impossible.
I only said I could not conceive of a situation in which it was advisable.

[frankge973]

Do you know if there is a way to transform the whole Firebird DB with case insensitive queries?

[clivew]

Originally Posted by frankge973

Do you know if there is a way to transform the whole Firebird DB with case insensitive queries?

No.