Linked Questions

6
votes
6answers
14k views

UTF-8 character encoding battles json_encode() [duplicate]

Quest I am looking to fetch rows that have accented characters. The encoding for the column (NAME) is latin1_swedish_ci. The Code The following query returns Abord â Plouffe using phpMyAdmin: ...
0
votes
1answer
16k views

PHP mysql charset utf8 problems [duplicate]

Possible Duplicate: UTF-8 all the way through I'm developing some new features on a website that somebody else already developed. I'm having a problem the charset. I saw that the database ...
3
votes
3answers
6k views

Getting special characters out of a MySQL database with PHP [duplicate]

I have a table that includes special characters such as ™. This character can be entered and viewed using phpMyAdmin and other software, but when I use a SELECT statement in PHP to output to a ...
1
vote
3answers
2k views

PHP special characters not showing [duplicate]

Can anyone help with with special characters and php. The following php: $IHaventReceivedCode = "Je n'ai pas reçu mon code"; is showing as: Je n'ai pas re�u mon code I have tried adding to ...
3
votes
0answers
6k views

how to force php to use utf-8 charset [duplicate]

errr im not sure if my question's title is clear enough but i'll try my best to explain i really am not sure about how php executes the function mysql_query in terms of retrieval and storageof ...
1
vote
2answers
1k views

how to echo special characters like åäö with utf8 [duplicate]

specialcharacters åöö in the database cant be shown when i retrieve the rows and echo it. what can i do to have them shown propertly?
1
vote
4answers
799 views

How can character encoding be made correctly in both php and mysql database [duplicate]

Possible Duplicate: UTF-8 all the way through Searching high & low for a solution. I've tried many variations before posting the question. What is required to have names appear the ...
-4
votes
1answer
3k views

UTF-8 with mysql and php in freebsd swedish chars (åäö) [duplicate]

Possible Duplicate: UTF-8 all the way through Hi I recently switched from linux to freebsb on my server, and now my database is acting up. When I try to echo a string containing å,ä or ö ...
0
votes
3answers
2k views

PHP is messing with the letters ä, ö, ü etc [duplicate]

Possible Duplicate: UTF-8 all the way through so i saved some data in a mysqlDB and its stored there with "umlauts". When i'm speaking of umlauts i mean these german letters: ö, ä, ü and ...
2
votes
1answer
1k views

Question mark characters on HTML if I use UTF-8 and weird characters on SQL data if I use ISO-8859-1 [duplicate]

I'm making a page with latin accents like á, ã, ç, and others. This site pulls data from a SQL database. I'm using this on the <head>: <meta http-equiv="content-type" content="text/html; ...
0
votes
2answers
209 views

Arabic not supported in mysql and php [duplicate]

I have this part of code that works fine only the arabic issue. $result = mysql_query("SELECT login, password, name, role FROM qm_users WHERE login = '$login'"); if (!$result) { die('Invalid ...
0
votes
1answer
518 views

Special Spanish Characters not displaying, Codeigniter MySQL [duplicate]

Spanish special characters are not displaying correctly, a word like: 'Árbol' is displayed like '�bol'. 1) Text in database is saved correctly. 'Árbol' looks perfect on database. 2) If I insert a ...
0
votes
2answers
365 views

UTF-8 special characters are inserting into table as weird characters [duplicate]

I searched in this site there were lots of answers but none of them are working for me. I am trying to parse the below XML using PHP simplexml_load_string. My XML is: <?xml version="1.0" ...
0
votes
1answer
448 views

Quotation marks from database being echo'd out as diamond question marks in chrome [duplicate]

I am having a strange problem in that when anything from my mysql database is retrieved and echo'd out in a php script the quotation marks in the record are being replaced by diamond shaped question ...
3
votes
3answers
94 views

MySQL encoding parsed wrong [duplicate]

Im trying to add some text with this command, included in my php file: $sql = "INSERT INTO $this->table_name_category (name, marker_icon) VALUES ('".$name."', '".$marker_icon."')"; Everything ...

15 30 50 per page