Skip navigation links

MySQL Forums :: Newbie :: Illegal mix of collations for operation 'concat_ws' Error 1271


Advanced Search

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 Bhanu Nadendla 09/10/2008 09:48AM
Re: Illegal mix of collations for operation 'concat_ws' Error 1271 Huu Da Tran 09/10/2008 02:34PM
Re: Illegal mix of collations for operation 'concat_ws' Error 1271 Bhanu Nadendla 09/11/2008 01:06AM
Re: Illegal mix of collations for operation 'concat_ws' Error 1271 Bhanu Nadendla 09/11/2008 01:33AM


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.