#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    5
    Rep Power
    0

    Angry 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.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,055
    Rep Power
    383
    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
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    5
    Rep Power
    0
    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
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,055
    Rep Power
    383
    FYI: I did not say it was impossible.
    I only said I could not conceive of a situation in which it was advisable.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    5
    Rep Power
    0
    Do you know if there is a way to transform the whole Firebird DB with case insensitive queries?
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,055
    Rep Power
    383
    Originally Posted by frankge973
    Do you know if there is a way to transform the whole Firebird DB with case insensitive queries?
    No.

IMN logo majestic logo threadwatch logo seochat tools logo