ID: 16163 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: MSSQL related Operating System: windows 2000 PHP Version: 4.1.2 New Comment:
is this a bug or not???? just anser me!!!!!!! Previous Comments: ------------------------------------------------------------------------ [2002-03-19 07:43:17] [EMAIL PROTECTED] Do NOT reopen a new report, reopen the old one. ------------------------------------------------------------------------ [2002-03-19 06:25:27] [EMAIL PROTECTED] 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'est la problFme No french special characters at all. Cris Badea Web Developer Tellme SA ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16163&edit=1