MySQL Forums
Forum List  »  Newbie

Re: Illegal mix of collations for operation 'concat_ws' Error 1271
Posted by: Bhanu Nadendla
Date: September 11, 2008 01:06AM

Hi Tran,

I have verified the Characterset for all Columns and it was same.


`col1` varchar(200) character set latin1 collate latin1_bin default NULL,
`col2` varchar(100) character set latin1 collate latin1_bin default NULL,
`col3` varchar(50) character set latin1 collate latin1_bin default NULL,
`col4` varchar(20) character set latin1 collate latin1_bin default NULL

And I have few more columns in the select clause and when I ran query with those columns, the query ran fine wihtout any error message.

When I include the following column definition with all other columns then I am getting the error message.

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

Options: ReplyQuote


Subject
Written By
Posted
Re: Illegal mix of collations for operation 'concat_ws' Error 1271
September 11, 2008 01:06AM


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.