#20166 [Opn->Bgs]: Unicode (Slovenian) characters are not displayed correctly
| From: | sniper@php.net | Date: | Wed, 30 Oct 2002 13:05:54 +0000 |
| Subject: | #20166 [Opn->Bgs]: Unicode (Slovenian) characters are not displayed correctly | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-23717@lists.php.net to get a copy of this message | ||
ID: 20166
Updated by: sniper@php.net
Reported By: miha.valencic@mobitel.si
-Status: Open
+Status: Bogus
Bug Type: *Languages/Translation
Operating System: Win2k
PHP Version: 4.2.2
New Comment:
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
Previous Comments:
------------------------------------------------------------------------
[2002-10-30 02:45:23] miha.valencic@mobitel.si
The problem is with Microsoft SQL Server 2000 and with MySQL version
Ver 11.18 Distrib 3.23.52, for Win95/Win98 (i32).
I have a database with slovenian characters in the fields and I am not
able to display them properly with php extension modules. I can display
them propery using COM ADO objects. I've included a simple script, that
shows what I am trying to do. The ADO portion of the script produces
the desired result. The characters are entered using windows-1250
codepage.
The script:
<PRE><?
header("Content-Type", "text/html; charset=Windows-1250");
?>
<html><head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1250">
</head>
<body>
<?
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("PROVIDER=MSDASQL;DRIVER={SQL SERVER};
Server=SRRDEV2;Database=portal;UID=sa;PWD=srrdev2;");
// SQL statement to build recordset.
$rs = $conn->Execute("SELECT * FROM TblInfo_News where IID = 3034326");
while (!$rs->EOF) {
$fv = $rs->Fields("title");
echo "title: ".$fv->value."<br>\n";
$rs->MoveNext();
}
$rs->Close();
?>
PHP Mssql extension:<br>
<?
$link = mssql_connect("srrdev2.mobitel.si", "sa", "srrdev2");
if($link) {
if(mssql_select_db("portal", $link)) {
$query = "SELECT * FROM TblInfo_News where IID = 3034326";
$result = mssql_query($query, $link);
if($result) {
if(mssql_num_rows($result)) {
while($row = mssql_fetch_array($result)) {
echo "title: " . $row['title'] . "<BR>";
}
} else {
echo "No results! <BR>";
}
mssql_free_result($result);
} else {
echo "Could not get the result!<BR>";
}
mssql_close($link);
} else {
echo "Could not select db!<BR>";
}
} else {
echo "Could not connect!<BR>";
}
// mysql
echo "MYSQL<BR>";
$link = mysql_connect("valencicm.mobitel.si", "root", "root")
or die("Could not connect");
mysql_select_db("test");
$query = "SELECT * FROM tbl1";
$result = mysql_query($query);
if($result) {
$row = mysql_fetch_array($result);
if($row) {
echo "String: " . $row['fld1'];
}
mysql_free_result($result);
}
mysql_close($link);
?>
</body></PRE>
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=20166&edit=1