#1 azwl
我需要把mssql2000的数据表导到mysql写了如下程序
function convert(){
$fromdsn = 'mssql:host=192.168.1.20;dbname=mybase';
$fromdb = new PDO($fromdsn, 'sa', '');
$fromdb -> query('set names utf8');
$stmt = 'SELECT top 100 * FROM cl_jihua';
$rs = $fromdb -> query($stmt);
while ($row = $rs -> fetch()){
$rows[] = array(
'lb' => $row[1],
'bz' => $row[2],
'rq' => date('Y-m-d', strtotime($row[3])),
'mc' => $row[4],
'gg' => $row[5],
'gys' => $row[6],
'dw' => $row[7],
'sl' => empty($row[8])?0:$row[8],
'dj' => empty($row[10])?0:$row[10],
'pzsl' => empty($row[9])?0:$row[9],
'wcsj' => $row[11],
'zs' => $row[12],
's1' => $row[13],
's2' => $row[14],
's3' => $row[15]
);
}
dump($rows);
// exit;
spClass('Mcljh') -> createAll($rows);
echo date();
}
转换到mysql中时字符字段乱码。用dump($rows)时，浏览器显示的是对的，问题出在哪里？
2010-04-25 18:21:52