Troubles with text encoding on spanish

Question

I have a webpage that has some text on spanish and some words have accents and spanish characters, on the webpage i have a datatable retrieving information, the thing is, when i use the tag:

<meta charset="iso-8859-1">

https://i.stack.imgur.com/ulybR.png

it displays correctly the text on the Footer, with accents, but the information from the datatable gets a lot of trash chars.

but then again, if i use the tag:

<meta charset="utf8"> or
<meta charset="latin1_spanish_ci">

https://i.stack.imgur.com/abhwR.png

i get the datatable information correctly, but the text on the footer now gets the trash chars.

Already tried with different encodings and combinatios of them and still not working.

Tables and database are on latin1_spanish_ci collate

inclined to close dupe: http://stackoverflow.com/questions/279170/utf-8-all-the-way-through — , Sep 02 '15 at 22:33
I forgot also, which API, `mysql_`, `mysqli_` PDO are you using to connect with? — Funk Forty Niner, Sep 02 '15 at 22:35
check out the link that Dagon left you above. Your answer may very well be in there. Usually passing utf8 through the connection before querying solves it. and yes, utf8 for accents. — Funk Forty Niner, Sep 02 '15 at 22:36
should i re do the database with ut8 collation for tables and database? — John doe, Sep 03 '15 at 00:40
well i have redone databse, made everything utf8, still not working :( — John doe, Sep 03 '15 at 01:12

score 0 · Answer 1 · answered Sep 02 '15 at 23:00

0

I would use the unicode encoding for the letters with diacritical marks.

answered Sep 02 '15 at 23:00

Adam

85
1
8

score 0 · Answer 2 · edited May 23 '17 at 12:14

0

please take this solution :

 <!DOCTYPE html>
  <html>
  <head>
  <meta charset="utf-8"><!-- Your HTML file can still use UTF-8-->
  <title>Untitled Document</title>
  </head>
  <body>
  <?php
   /*Just for your server-side code*/
  header('Content-Type: text/html; charset=ISO-8859-1');
  echo "àè";
  ?>
  </body>
  </html>`

I got it from here How to display special characters in PHP

edited May 23 '17 at 12:14

Community

1
1

answered Sep 02 '15 at 23:21

Mohammed Elhag

4,272
1
10
18

sorry, this gives me the same result as before. – John doe Sep 03 '15 at 00:39
change àè by your string and check with same code and let me know – Mohammed Elhag Sep 03 '15 at 00:41
oooh ok, let me check. – John doe Sep 03 '15 at 00:42
I mean , copy this code and save it as test.php page , then try to see the result when you take out header('Content-Type: text/html; charset=ISO-8859-1'); and when you keep it – Mohammed Elhag Sep 03 '15 at 00:48
its work fine for me , please show me your code , you can edit your question and add your code – Mohammed Elhag Sep 03 '15 at 00:53

score 0 · Answer 3 · answered Sep 03 '15 at 01:52

What bytes to you have in the source? (Provide hex)
What did you use when calling mysqli_set_charset()
What is the CHARACTER SET on the column in the table?
What <meta ... charset...> did you have.

Please state all for, plus any output.

To show the hex from PHP, use

$hex = unpack('H*', $text);
echo implode('', $hex);

To show the hex in the table, do

SELECT col, HEX(col) FROM tbl WHERE ...

With the answers we can pin down what you did wrong and how to fix it.

score 0 · Answer 4 · answered Sep 03 '15 at 03:09

Ok, what i did was use the second option, the one where the information from the database was correct, and for the footer information i used escape characters ÓÑ maybe not the best solution, but after breaking my head all afternoon i think this one is the easier.

Troubles with text encoding on spanish

4 Answers4