Databases Reference
In-Depth Information
There is no
MySQL Charset
selector. The character set defined in the chosen
Language
(here
English iso-8859-1)
will be used to communicate with MySQL.
Choosing the Effective Character Set
Now, we set
$cfg['AllowAnywhereRecoding']
to
TRUE
. Then we choose
English
(en-utf-8)
in the
Language
selector. The
Home
page has changed:
The
MySQL Charset
choice appears only if the current chosen
Language
uses
utf-8
encoding. From now on, every communication that occurs between the web server
and the MySQL server will use this MySQL character set.
The choice of character set is remembered for 30 days using
a cookie mechanism. Depending on where the cookies are
stored (on the local computer or on a network server), the
character set may need to be chosen again if we log in to
phpMyAdmin from another computer.
The Impact of Switching
When we choose a character set, all the data stored in MySQL will be recoded with
this character set. If we subsequently change the character set used by phpMyAdmin,
we will get incorrect results when fetching the data. There is no easy way of finding
which character set was used to store a particular row of data.
Search WWH ::
Custom Search