Monday, 30 September 2013

utf8_encode() is not fully converted unicode character?

utf8_encode() is not fully converted unicode character?

I'm trying to converting unicode data from mssql database to mysql
database. I used like that..
<?php
$server="192.168.20.14\SQL2005";
$link = mssql_connect($server,'sa','password');
mssql_select_db('tabbook',$link);
$qry=mssql_query("SELECT * FROM category");
while($row=mssql_fetch_assoc($qry))
{
$string = utf8_encode($row["name"]);
echo $string;
}
?>
It worked. But some character are left because of utf8_encode()
function.For example: a data in mssql database is "English-Myanmar
(£"½â¶ý-íºÌýºà)" and when echo string in php it produce "English-Myanmar
(£½â¶ý-íºÌýºà)". You will see '"'have left. I don't know which function
to use for converting correctly . Suggestion please! i'll look forward
urs.
(sorry for my bad english).

No comments:

Post a Comment