Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
889 views
in Technique[技术] by (71.8m points)

php - Reading signs like ? ? ? ? ? from MySql database

I have problems reading signs '?', '?', '?', '?', '?' from MySQL database.

I have tried few suggestions that I found on the internet, but none worked. I am looking for correct combination of charset in the database and in PHP file. So far I have always used UTF.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
  • Set table and db charset, collation, etc. to utf8_general_ci

  • After establishing connection from php, be sure to do SET NAMES UTF8. That step is very important.

  • Make sure you saved all PHP files using utf-8 encoding (that was common cause several years ago)

  • <meta http-equiv="Content-type" content="text/html; charset=utf-8" />

I'm from Slovenia, where we use these 'special chars', and believe me, this is our everyday problem ;)


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...