UTF8 issue with Illegal mix of collations

Question

Really hope someone can advise.

Just moved the database to Amazon RDS. Part of the move was to update the database to utf8 which went well.

I have a query which is giving me an error which is.

SELECT
    *
FROM
    (`specialdaterange`)
WHERE
    `parkinglotsproduct_id` = 769
AND '02/15/2014' >= `from`
AND '02/15/2014' <= `to`
LIMIT 1

Error:

Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '>='

Now none of that data is text form but as you can se enter image description here

Also I have made sure the parameters are correct on RDS: enter image description here

Im not sure where the latin1_swedish_ci is coming from?

Really hope you can advise.

possible duplicate of [Illegal mix of collations in mySQL](http://stackoverflow.com/questions/2327778/illegal-mix-of-collations-in-mysql) — Axel Amthor, Feb 09 '14 at 15:52
possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — M Khalid Junaid, Feb 22 '14 at 11:55

score 0 · Accepted Answer · answered Feb 09 '14 at 15:49

0

i think you should use date as this format yyyy-mm-dd .

SELECT
    *
FROM
    (`specialdaterange`)
WHERE
    `parkinglotsproduct_id` = 769
AND '2014-02-15' >= `from`
AND '2014-02-15' <= `to`
LIMIT 1

answered Feb 09 '14 at 15:49

ImadOS

Yea now feel dumb. But crazy how tah has not sown up before !! – Lee Feb 09 '14 at 16:12

1 Answers1