Databases
StackOverflow2013
Postsdbo
POSpanish Characters Not Encoding Correctly
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSpanish Characters Not Encoding Correctly
    text
    copied!<p>I'm working on a project in the Philippines where many people have special Latin tilde characters in their names.</p> <p>I have a database set up with all tables in latin1 with latin1_swedish_ci collation.</p> <pre><code>+--------------------------+--------------------------------+ | Variable_name | Value | +--------------------------+--------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | C:\xampp\mysql\share\charsets\ | +--------------------------+--------------------------------+ </code></pre> <p>My webpage headers declare iso-8859-1 as the character set.</p> <p>When I submit an employee name containing a tilde character through my web forms, for example, it appears in my table as 'Marie Cañon' and appears the same on my webpages when I look at the employee's record.</p> <p>If I change the webpage encoding to utf-8, it displays correctly as 'Marie Cañon'. So, I'm assuming that somehow I'm encoding UTF-8 in my latin1 tables. But I'm confused where that could be occurring.</p> <p>As far as I know, PDO doesn't deal with encoding. My webpages are declared iso-8859-1, so I'm figuring PHP isn't causing the problem. My character_set_connection is latin1 in MySQL.</p> <p>Where could this be happening?</p> <p>Additional Information: Ubuntu 10.04.2 LTS MySQL 5.1.41-3ubuntu12.9-log PHP5: 5.3.2 Apache2: 2.2.14</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload