MS SQL Server - 'ICÔNE' and 'ICONE' in SQL_Latin1_General_CP1_CI

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

'ICÔNE' and 'ICONE' in SQL_Latin1_General_CP1_CI_AI

t2581@hotmail.com

2005-07-15, 11:23 am

Hi,
our 2000 server use SQL_Latin1_General_C
P1_CI_AI collation

We enter English and French text data into db

Is it normal that query return 'IC=D4NE' and 'ICONE' in all cases
see example
create table #test(a char(5))
insert into #test values('IC=D4NE')
insert into #test values('ICONE')

select * from #test where a =3D 'IC=D4NE'
select * from #test where a =3D 'ICONE'
select * from #test where a like 'IC=D4NE'
select * from #test where a like 'ICONE'
=20
thank you
Alex

Sponsored Links