dpjhq00684
2013-06-13 12:28
浏览 86
已采纳

使用mysql_real_escape_string编码错误,返回空字符串

The scenario: An html-document that's used for editing product details is encoded as ISO-8859-1, and sends POST data to a PHP-file (also encoded ISO-8859-1). That PHP-file in turn has mysql_real_escape_string -functions cleaning the inputs. The database/mysql server charset is UTF-8. The problem is that when a POST string has scandinavian letters (ä,ö,å) in it, the mysql_real_escape_string returns an empty string.

I tried to override it with utf8_encode/decode, but it won't work.

Now, if I change the html&php-files to use UTF-8, saving works fine (as expected), but then all previously saved product data looks corrupt, and there are thousands of product rows.

What would be the easiest solution to fix it? Change the db charset? Run a encoding function to convert the entries in the db?

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • donglipi4495 2013-06-13 13:09
    已采纳

    mysql_real_escape_string considers the current connection character set. Your ISO-8859-1 scripts should work if you set your connection explicitly to UTF-8 before calling mysql_real_escape_string (query "SET NAMES 'utf8'" before using mysql_real_escape_string)

    But for sure I would always recommend to use unicode (and only unicode) wherever it is possible;)

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题