dqg63264 2013-03-25 19:54
浏览 93

PDO mysql UTF-8编码问题[关闭]

I'm using database made for utf8_general_ci, tables are also utf8_general_ci and everything what can mess up with encoding is set to utf8_general_ci.

My connect string for PDO looks like this:

try {
    $new = new PDO('mysql:host=' . $config['host'] . ';dbname=' . $config['database'] . ';charset=utf8', $config['username'], $config['password'], array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
    $new->exec('SET NAMES utf8');
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}

Unfortunately after select from database my encoding gets messed up. Can anyone tell me what am I doing wrong?

  • 写回答

2条回答 默认 最新

  • douleng3463 2013-03-25 20:30
    关注

    Thanks to Your Common Sense answers I've managed that there were other problem with encoding. Weird characters instead of original ones was displayed because of console encoding.

    评论

报告相同问题?

悬赏问题

  • ¥100 c语言,请帮蒟蒻写一个题的范例作参考
  • ¥15 名为“Product”的列已属于此 DataTable
  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)