Re: Illegal Collation
Posted by:
Rick James
Date: February 28, 2013 08:56PM
Do not use VARCHAR _anywhere_ for DATEs or DATETIMEs. That include SP parameters, expressions, columns, etc.
(Yes, there are exceptions.)
SHOW CREATE PROCEDURE PopulateClassWeek;
If that fails to show the charset and collation for the SP, then rummage in information_schema to find it.
SHOW CREATE TABLE for the table involved.
Subject
Views
Written By
Posted
2441
February 28, 2013 04:12AM
1059
February 28, 2013 11:56AM
Re: Illegal Collation
1127
February 28, 2013 08:56PM
1046
March 01, 2013 06:08AM
1196
March 01, 2013 09:59AM
1063
March 01, 2013 11:43AM
1105
March 01, 2013 04:45AM
1818
March 20, 2013 01:10AM
1230
March 20, 2013 10:29AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.