Problems with character encoding (UTF-8 vs ISO-8859-1)
In MySQL coding I use is utf8_general_ci and use HTML charset = UTF-8.
At the outset, it seems that everything should go well!
It turns out that by default when the connection is made to MySQL, the used charset is latin1, which soon spoils the view of the characters (special).
The best solution I got was to put the following statement, following the definition of the database connection (mysql_connect):
# mysql_set_charset ('utf8', $ link);
If you do not use this queisram solution and just want to change the display of one or another variable, one can use the following instructions:
# utf8_encode ($ string);
# htmlentities ($ string);
Normally I use xampp for Linux (lampp) to program these platforms, but must also occur in other (even Windows users). This happens to me always to the point of me going through with this, so today I decided to spend one hour of my life researching with feet and head on this.
The character encoding is a subject that gives cloth sleeves! Anyway I think these statements in PHP already help a lot.
Popular Posts
-
On some Linux distributions engine that comes by default may not be your favorite . In my case I'm currently using Linux M... -
Corel Aftershot ( CA) is a tool equivalent to Adobe's Lightroom . Both are targeted at photographers ( or those with mania, ... -
If you use XAMPP , can happen to you the problem of MySQL does not start . This usually happens when we copy the XAMPP folde... -
If you work with more than one computer on your desk, to be sure you felt the need for a utility to share the keyboard and mouse between t...
-
As you know already available version 3.6 of LibreOffice as announced in pplware . You can read more information about new fe... -
The youtube-dl is a small command-line utility that can download videos from youtube.com too easily. In terms of archives, from the Debian M... -
If you have problems mounting a floppy drive in linux , you may be receiving the following message : " / dev / tty is not ... -
Whenever I need to do something in HTML, PHP and / or MySQL , here comes the problem of character encoding ! In MySQL coding I us...
-
At one time published an article, which can read here on remote display in Linux. Now, I will publish another way that allows remote connec... -
What about Google Chrome? Sure already heard! To begin with, in my opinion has great control, which is not getting out (02-September-2008) a...
