MySQL Forums
Forum List  »  Newbie

Illegal mix of collations for operation 'concat_ws' Error 1271
Posted by: Bhanu Nadendla
Date: September 10, 2008 09:48AM

Hi All,

I am running follwoing query in Mysql.

select
CONCAT_WS('',TRIM(Col1),CASE when LENGTH(col2)=0 then '' when col2 IS NULL then '' when LENGTH(col2)=1 then '' else ',' end,col2,',',col3 , ',' , col4) AS ADDRESS
from
LOCATION l

and getting the error message:

"Illegal mix of collations for operation 'concat'"

Does anybody know this error message.


Thanks
Bhanu Nadendla



Edited 2 time(s). Last edit at 09/10/2008 09:53AM by Bhanu Nadendla.

Options: ReplyQuote


Subject
Written By
Posted
Illegal mix of collations for operation 'concat_ws' Error 1271
September 10, 2008 09:48AM


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.