Tag Archives: sql
Finding international characters with MySQL
I recently had to find the rows in a database that contained any multibyte characters. My first thought was to leverage the difference between length() and char_length(). The query would be similiar to this: Select pKey, dataCol From myTable Where … Continue reading
Format your SQL
The other day I was complaining on twitter about a almost 2000 character wide SQL Insert statement that I had to debug. Enough with the complaining, I’d like to show how I format SQL statments in my code. In the … Continue reading