>Let say I have this table:

City
>----
>Notre-Dame-de-L'Ile-Perrot
>Notre-Dame-de-l'Ile-Perrot

When I run this query

SELECT City, Count (*) FROM MyTable GROUP BY 1

I have this result:

Notre-Dame-de-L'Ile-Perrot, 2

What I want is:

Notre-Dame-de-L'Ile-Perrot, 1
>Notre-Dame-de-l'Ile-Perrot, 1

How can I get this result?
>
>TIA

What's your current setting for SET COLLATE? If it's MACHINE, it should be OK. Maybe you have an index that was created with a different COLLATE setting?