December 1st, 2010, 10: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?
December 1st, 2010, 11: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.
December 1st, 2010, 11: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
December 1st, 2010, 02: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, 03:34 PM
Do you know if there is a way to transform the whole Firebird DB with case insensitive queries?
December 1st, 2010, 04:32 PM
Originally Posted by frankge973