I hava database mysql charset utf-8. I want to covert this database to sql 2000. I have writen one program by php use ODBC. But data utf-8 insert to sql 2000 error font. This is code program write by php.
define('DB_HOST', 'localhost');
define('DB_SPA_USER', "user");
define('DB_SPA_DIC', "tudien");
define('DB_USER', "root");
define('DB_PASSW', "123456789");
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSW) or die("Cound not connect to DB !!");
mysql_select_db(DB_SPA_DIC) or die("Could not select DB !!5");
$query= "SELECT * FROM en_vi ";
$result = mysql_query($query) or showerror();
$conn=odbc_connect("tudien","","");
if(mysql_num_rows($result)!=0)
{
while($row=mysql_fetch_row($result))
{
$conn=odbc_connect("tudien","","");
echo $row[0]."<br>";
echo $row[1]."<br>";
echo $row[2]."<br>";
echo $row[4]."<br>";
// echo $row[4]."<br>";
print utf8_encode($row[4]);
$d_id = $row[0];
$word = htmlspecialchars($row[1],ENT_QUOTES);
$pho = htmlspecialchars($row[2],ENT_QUOTES);
$d_in = $row[3];
$mean = htmlspecialchars($row[4],ENT_QUOTES);
$d_word = utf8_encode($word);
//echo $d_word;
//$d_pho = utf8_encode($pho);
//$d_in = $row[3];
$d_mean = utf8_encode($mean);
$sql = "INSERT INTO en_vi VALUES('$d_id','$d_word','$d_pho','$d_in',N'$d_mean')";
//$row=odbc_exec($conn, $sql);
echo "Inser new record.....!!!!";
}
}
odbc_close($conn);