phpMyAdmin - #1267 - Illegal mix of collations for operation '<'

Question

I am getting an error when trying to run the following SQL:

SELECT * FROM syshealth WHERE 'timestamp' < DATE_SUB(NOW(),INTERVAL 15 MINUTE)

I am getting the following error:

#1267 - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '<'

I have my table and database collation set to utf8_unicode_ci

I have read a few articles already, and have tried the top answer here, but without success...

Any more idea's?

EDIT: Additional Info - the 'timestamp' column is of type datetime

use backticks to escape column names, not quotes – juergen d Oct 08 '14 at 17:17 — juergen d, Oct 08 '14 at 17:17

score 1 · Accepted Answer · answered Oct 08 '14 at 17:21

1

You need to use ` (backtick) to identify a column if you use single ' , this will be treated as string literal.

SELECT * FROM syshealth WHERE `timestamp` < DATE_SUB(NOW(),INTERVAL 15 MINUTE)

answered Oct 08 '14 at 17:21

radar

Great! Worked first time. Does the same rule apply, if I was to execute this within PHP? – dankellys Oct 08 '14 at 17:34
@dankellys, yes same rules with in PHP – radar Oct 08 '14 at 17:48

1 Answers1