I'm using phpMyAdmin to handle my tables.
my database encoding is UTF-8 (I've transformed its collation - inside 'operations' tab to utf8_general_ci).
The table's encoding is UTF-8 (I've transformed its collation - inside 'operations' tab to utf8_general_ci).
as well as the written text fields within the table are utf8_general_ci.
The truth is by using this the browser display strange question marks (but other non-database text can look properly):
<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8" />
with this line the browser shows database-data properly (but other texts is unreadable):
<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=windows-1255" />
I suppose which means the the database is encoded in "home windows-1255" - why ?! How do i define so that it is utf-8 and display for me personally non-latin figures? It is possible to method of doing it in phpMyAdmin? and what shall we be held doing wrong?
Your database ought to be in UTF-8 (You should check it in PHPMyAdmin)
Your connection ought to be in UTF-8 (before first query:
SET NAMES utf-8 or default somewhere in configurations)
Your meta-tag or header ought to be UTF-8 (
Content-type: text/html; charset=utf-8)