problems with inserting french special

[Anon]

Here is the script that is supposed to insert in a MS SQL Server database
some data including special french characters:

<?
// establish connection to database
setlocale("LC_ALL","french");
$li=mssql_connect("server", "user","password");
$db=mssql_select_db('database',$li);

     // text to insert, written in french
$test='voilà ça c'est la problème';

$query="insert into toto values ('".$test."')";
$rez = mssql_query("SET LANGUAGE french");
$rez = mssql_query($query);

    // extract from db the data just inserted
$query="SELECT test from toto";
$qresp=mssql_query($query);
$toto = mssql_fetch_array ($qresp);

    // display the result
echo $toto[0]; 
mssql_close($li);

?>

Here is what the database contains:
voila ta c&#039;est la problFme

No french special characters at all.
any idea????

Cris Badea
Web Developer
Tellme SA

[Anon]

replace ç in &ccedil;

[Anon]

sorry the program replaces my code.

replace ç in '&ccedil;'

[Anon]

again

raplace ç in &_ccedil; remove the underscore.

i put it into else the program replace the code into ç.

[Anon]

it is not posible to do like this because i want to have a clean database only with french characters......

i just made like this but is not ok....

the problem is that mssql support french characters but i think that the module mssql does not support special characters like éçàèù....

so i think this is a bug of the PHP!!!

any others ideas?????