mssql_query accent

Question

I hava a problem with this mssql_query in PHP :

$query = 'SELECT Ville FROM tblLstManufacturiers where province = "Québec"';

The result is empty because I have an accent in Québec

How can I do this?

Answer 1

SELECT Ville
FROM tblLstManufacturiers
WHERE province = N'Québec' COLLATE Latin1_General_CS_AI