duanqian2278 2018-07-07 06:58
浏览 289

如何为PDO ODBC设置字符集?

I'm using MDB(Microsoft Access) file as database and unfortunately all Persian characters converted to question signs (?????)

I have using PDO and ODBC extension:

$conn = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".$config['mdb_path']."; charset=utf8");
$conn->exec('SET NAMES utf8');
$conn->exec('SET CHARACTER SET utf8');
$conn->setAttribute(PDO::FETCH_ASSOC, true);

$sql = "SELECT * FROM `paylist`";
$exec = $conn->query($sql);
$results = $exec->fetchAll();

I have set all configs to utf8 but I don't know why still all Persian characters converted to ????

Thank you

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 matlab yalmip kkt 双层优化问题
    • ¥15 如何在3D高斯飞溅的渲染的场景中获得一个可控的旋转物体
    • ¥88 实在没有想法,需要个思路
    • ¥15 MATLAB报错输入参数太多
    • ¥15 python中合并修改日期相同的CSV文件并按照修改日期的名字命名文件
    • ¥15 有赏,i卡绘世画不出
    • ¥15 如何用stata画出文献中常见的安慰剂检验图
    • ¥15 c语言链表结构体数据插入
    • ¥40 使用MATLAB解答线性代数问题
    • ¥15 COCOS的问题COCOS的问题