SEARCH

The How-To Geek Forums Have Migrated to Discourse



Join the Discussion at discuss.howtogeek.com

How-To Geek Forums / Geek Stuff

MySQL Case Sensitive SELECT

(4 posts)
  • Started 5 years ago by jmcguire
  • Latest reply from The Geek
  • Topic Viewed 3284 times

jmcguire
jmcguire
Posts: 552

I changed my database table's collation to latin1_general_cs but it still allows for case insensitive searches.

Does anyone know anything else I need to do?

Posted 5 years ago #
Top
 
thegeek
The Geek
Posts: 2059

Did you actually change the column collation, or just the default one for the table? MySQL will use the collation on the column itself.

It's also possible to modify the SQL statement to pass in the collation you'd like to use, so there's some potential that your SQL is doing something like " USING latin1" at the end.

http://dev.mysql.com/doc/refma.....ivity.html

http://dev.mysql.com/doc/refma.....table.html

Posted 5 years ago #
Top
 
jmcguire
jmcguire
Posts: 552

Thank you. I did not change the column, just the table. I went back and changed the column and it fixed it.

Posted 5 years ago #
Top
 
thegeek
The Geek
Posts: 2059

Glad to hear that helped!

Posted 5 years ago #
Top
 



Topic Closed

This topic has been closed to new replies. Please create a new topic instead.


Create New Topic Return to Forum