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.

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

and getting the error message:

"Illegal mix of collations for operation 'concat'"

Does anybody know this error message.

Bhanu Nadendla

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

Options: ReplyQuote

Written By
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.