blog.pagesd.info // Archives // Traductions

(Wdevs) MySQL case sensitivity

2004-11-02 #qc,#wdevs

I rename qc_portals to qc_Portals and qc_screens to qc_Screens since my SQL code in Portals.cs and Screens.cs differs from my SQL scripts to create tables.

I’m not sure, but last week it seems that I have an error with “SELECT … FROM qc_Portals” when running on monoForge. I don’t have such an error on my local database.

I don’t know where it come from:

  • I made a mistake,
  • It come from MySQL on a Linux platform,
  • It’s from MySQL Connector/Net,
  • It’s because I use InnoDB engine instead of MyISAM,
  • MySQL on monoForge don’t accept “CHARSET=utf8” in “CREATE TABLE”

Normally, I don’t like languages with case-sensitivity, except when the editor manages all that for me, as with VS.NET and C#. But in practice, I tend to use it in my SQL command so that my code is prettier. So, it’s not a problem and for the moment I will not seek after this behavior.