-- Take care to the collate of the fields
create table TestCollate (
aaa varchar(10) COLLATE Latin1_General_CS_AS_KS_WS,
bbb char(10) COLLATE Traditional_Spanish_ci_ai
insert into TestCollate( aaa, bbb ) values (' Test 1',' Test 2');
select concat( aaa, bbb ) from TestCollate;
-- ERROR: Cannot resolve the collation conflict between "Latin1_General_CS_AS_KS_WS" and "Traditional_Spanish_CI_AI" in the concat operation.