ID: 16163
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: windows 2000
PHP Version: 4.1.2
New Comment:
Do NOT reopen a new report, reopen the old one.
Previous Comments:
------------------------------------------------------------------------
[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
