sort accent char correctly

[Sylvain Le Gourri�rec]

hello,   I know that topic was discussed a few days ago but I do not remenber how the problem was solved!     In french, we love to use � � � � �...   But revolution sort 'Canon, Crayon, C�ble' instead of 'C�ble, Canon, Crayon'.     How can I quickly obtain this result?     thanks --------------------------------------------------------------------------------------------------------------------------------------------- Sylvain Le Gourri�rec  ��  d�veloppement  �� son-video-distribution   www.son-video.com   ------------- I am working with Windows 2000, Revolution 1.1.1, MySQL 3.23 & PHP 4