Bug #16163 Updated: bug for french characters
| From: | sander@php.net | Date: | Tue, 19 Mar 2002 12:43:17 +0000 |
| Subject: | Bug #16163 Updated: bug for french characters | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-2869@lists.php.net to get a copy of this message | ||
ID: 16163
Updated by: sander@php.net
Reported By: cris@tellme.net
-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] cris@tellme.net
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