String delimeter mysql on centos linux
Posted on 2007-11-18
I have a centos linux installation I think I am having trouble with the os or mysql and the string delimeter, when I can't seem to execute a query that has a string parameter in it, maybe it is a syntax issue
I have tried the following
Select * from users where surname = 'jones'
Select * from users where surname = "jones"
I am getting a 1054 error from MySQL unknown column in field list
I can execute a sql query without the where clause successfully and if I put a none string datatype in the where clause seems to execute fine as well.
I have noticed something weird about my centos install anyway in that I need to press the ' key twice fro the character to appear, also " has the same odd behaviour, do I have my system on the wrong encoding.
I am going to try a different keyboard see if it makes a difference