Getting weird characters when fetching value in my

2020-02-15 04:10发布

站内问答 / PHP
1561 2 6

I'm getting this kind of result in my database ’ everytime i'm typing this character ’

I already use mysql_query('SET CHARACTER SET utf8'); when fetching data from my database.

I already have <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />..... this one on my HTML.

What else is lacking here? Your help would be greatly appreciated and rewarded!

Thanks!

2条回答
何必那么认真
2楼-- · 2020-02-15 04:13

try to do a select with a charset collate and use utf8_bin like this: 

SELECT k COLLATE utf8_bin AS k1
FROM t1
ORDER BY k1;

if it works for you, you can change the collate for a column by using alter table, here is an example I used today for one of my dbs: (you could do this also with phpMyAdmin easily) 

ALTER TABLE  `users` 
CHANGE  `name`  `name` VARCHAR( 255 ) 
CHARACTER SET utf8 COLLATE utf8_bin NOT NULL

but make a backup first!

查看更多
0人赞 添加讨论(0) 举报
爷、活的狠高调
3楼-- · 2020-02-15 04:21

I notice that you're running this query... mysql_query('SET CHARACTER SET utf8');
Try changing that to this... 

mysql_query("SET NAMES 'utf8'");

That should ensure that the connection is UTF-8.

Also try going through the list of items on this article... http://blog.loftdigital.com/blog/php-utf-8-cheatsheet
This lists the steps that are needed to make sure you're using UTF-8 from front to back in your site/application but in summary:

  • Check you've got PHP's mbstring extension and you have mb_internal_encoding('UTF-8'); set in your script.
  • Make sure you're running this MySQL query after connecting to your database mysql_query("SET NAMES 'utf8'"); which ensures the connection is UTF-8.
  • Set the HTTP header of your output... header('Content-type: text/html; charset=UTF-8');. This doesn't seem to be needed if you've set mb_internal_encoding() above but useful for debugging
  • Make sure the output encoding of your HTML page is set... <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
查看更多
0人赞 添加讨论(0) 举报
登录 后发表回答
相关问题
查看全部
相关文章
查看全部
收藏的人(6)