Re: Illegal mix of collations for operation 'concat_ws' Error 1271

[Bhanu Nadendla]

Hi Tran,


I have found the workaround.

The reason is, in the follwoing column I have used the CASE function and the CASE functions result set datatype is undefined.I have used the CAST function to convert it to CHAR and it was working fine.

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


Thanks
Bhanu Nadendla