{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 别忘想泡老子 的问题《Incorrect encoding from PHP?》','https://www.manongdao.com/q-1117997.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
1) I have a table tbl_Data in database which has name column with text comparision method (?) property set toutf8_polish_ci. Works as a charm, when I'm browsing tbl_Data through phpMyAdmin.
2) In my html code I've got:
<!DOCTYPE HTML>
<html>
<head>
<meta charset="UTF-8">
so seems like I'm sending proper encoding headers for browser...
3) My PDO dsn contains ;charset=UTF-8, followed from php manual.
4) In my php code I use:
foreach(parent::query('SELECT ID,PLName,LatinName from tbl_Data') as $row) {
$result = $result."
<tr>
<td>".utf8_encode($row['PLName'])."</td>
</tr>
";
}
Having all of this I'm still getting 'garbage' (=?) chars instead of proper polish letters, though some of them are displaying well (phpMyAdmin shows all properly). What I am missing here? Please advice, fellows!
My MySQL Engine is InnoDB, webserver: nginx with fpm if it is revelant...
Wrong.
<meta>is not an HTTP header but HTML tag, a non-standard one. So, your code still lacks proper header.if your PHP version is less than 5.3.6 it won't work either. use
SET NAMES utf8regular query insteadThere is no reason to use
utf8_encode()if your text is already UTF-8 encoded.A potential issue might be your version of PHP. The
;charset=UTF-8element of your DSN is only supported by PHP version >= 5.3.6. Prior to 5.3.6 this element was silently ignored (instead of issuing a warning). More information and a workaround for this are available in the docs: http://php.net/manual/en/ref.pdo-mysql.connection.phpCharset UTF-8 is good (in your html) :P
Try this.. (use new, experimental table for this, to check it out because I have no idea if your PHP script is cleaning $_POST entries for example, or doing something at all..)
create column set to
utf8_bin(not utf_ci_polish) named "polish_title"Before PHP passes (text input, polish) data to mysql
INSERT (or update)covert those with this (PHP integrated) function$polish_input = htmlspecialchars($input_polish_data);
INSERT INTO table_name (polish_title) values ('$polish_input');
You will see strange data in mysql table (via phpmyadmin) when polish signs are part of your input what is normal (or blobed), but good ones (polish native) on your site when you get mysql data out ;)
If this gonna work, ALL your mqsql (text) columns should be changed to utf8_bin. And to easy entries on yourself, you can create function which can "clean" all $_POST inputs on your website before those inputs engage to mysql DB.
Big plus on this is that visitors from other countries will see your native letters & signs (what is also important).
Edit (thx to Common Sense user input)
ANd yeah include this as a MUST also in your header
In your HTML code, try:
I could not comment on your post.....so I suggest here~_~
From here, it said utf8_encode — Encodes an ISO-8859-1 string to UTF-8
therefore, my question is: is your output is ISO-8859-1?
may be you could create a normal English test record and try again.