Collation set to latin1_swedish_ci incompatible with latin1_bin
I have a database which I use fo a CMS system called WebGui. Using the phpMyAdmin Tool I see that the collation of the tables is latin1_swedish_ci (this is the system default).
The update to the CMS inserted tables and created them as latin1_bin.
The references between the tables Generate an incompatibility error.
Couldn't execute prepared statement: select * from asset,Navigation,wobject,assetData where asset.assetId='f2bihDeMoI-Ojt2dutJNQA' and (asset.assetId=Navigation.assetId and Navigation.revisionDate=1124395696) and (asset.assetId=wobject.assetId and wobject.revisionDate=1124395696) and (asset.assetId=assetData.assetId and assetData.revisionDate=1124395696) : With place holders: . Root cause: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='
It seems that the collation differences is getting in the way, and that the update from the software has given me problems.
How do I reset the incompatible tables in the easiest manner?
And briefly, what value does collation provide?
Subject
Views
Written By
Posted
Collation set to latin1_swedish_ci incompatible with latin1_bin
4709
June 27, 2007 10:22PM
2596
July 06, 2007 09:08PM
Sorry, you can't reply to this topic. It has been closed.
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.