Mysql is not converting strings to integers?

I just reinstalled mysql on debian and now the following is not working

SELECT * FROM table WHERE id='1';

It is returning an empty set. This was working before. Normally doesn't it convert the string to an integer? Is this a mysql setting somewhere?

asked Feb 3 at 5:27

High
1627

64% accept rate

	I assume you have read the Mysql docs, and compared the docs for whatever 'previous' experience you had with the version you are currently running? dev.mysql.com/doc/refman/5.5/en/type-conversion.html BTW, what version of MySQL ARE you running? – Zoredache Feb 3 at 7:50
	I am using debian squeeze's mysql which is version "5.1.49". The only thing I think has changed is now its using the mysqli extension but that shouldn't matter should it? – High Feb 4 at 14:57

feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

asked	3 months ago
viewed	27 times