December 1st, 2010, 09:27 AM
-
Case Insensitive Queries
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.
December 1st, 2010, 10:23 AM
-
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
December 1st, 2010, 10:36 AM
-
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
December 1st, 2010, 01:02 PM
-
FYI: I did not say it was impossible.
I only said I could not conceive of a situation in which it was advisable.
December 1st, 2010, 02:34 PM
-
Do you know if there is a way to transform the whole Firebird DB with case insensitive queries?
December 1st, 2010, 03:32 PM
-
Originally Posted by frankge973
Do you know if there is a way to transform the whole Firebird DB with case insensitive queries?
No.