Echo different languages from php

Question

Possible Duplicate:
How I can solve my PHP web page file language encoding?

I have different langaues data in database(mysql).But when I select and echo a data in html page it will show as question marks"????" Why is that? How can I overcome this?

you should everything(html, database, connection to database froom any lang) in one encoding (e.g UTF-8) — RiaD, Jul 28 '12 at 17:53
I*'m out of votes: http://stackoverflow.com/questions/6516589/how-i-can-solve-my-php-web-page-file-language-encoding — John Conde, Jul 28 '12 at 17:55

score 0 · Answer 1 · edited May 23 '17 at 11:55

0

It could be a character encoding problem. Which character encoding are you using and which one your is browser using?

There is a similar topic discussed here so you can also check it: How I can solve my PHP web page file language encoding?

edited May 23 '17 at 11:55

Community

1
1

answered Jul 28 '12 at 17:52

Tarik

79,711
83
236
349

its utf8_general_ci how can I set it for the browser? – Lahiru Chathuranga Jul 28 '12 at 17:54
Are you sending this as content header? Please check the question in the link I gave you. He shows how to set headers in PHP. And also always try to use UTF-8. – Tarik Jul 28 '12 at 17:56
Im not using any headers..just load from the database and diplay – Lahiru Chathuranga Jul 28 '12 at 18:03
As I am telling you use "UTF-8" and then use `header("Content-Type: text/html; charset=UTF-8")` then you should be good. Don't forget to check the char-set in DB too. – Tarik Jul 28 '12 at 21:22

Joren Van Severen · Answer 2 · 2012-07-28T18:05:07.200

0

Probably your html-page is using a different character encoding as your mysql. Make sure to convert your text to the correct character encoding.

EDIT: Knowing now that your database uses utf8 encoding then another possibility is that the text you inserted in your database is not compatible with the utf8 encoding. So either encode the inserting data to utf8 or change both html page and database to ISO-8859-1 encoding (which is usually the correct one).

edited Jul 28 '12 at 18:05

answered Jul 28 '12 at 17:52

Joren Van Severen

2,269
2
24
30

my database is using utf8_general_ci.But how can I set same encoding to the page? doesnt work?? – Lahiru Chathuranga Jul 28 '12 at 17:59
I've edited my answer with another possibility where it is going wrong. – Joren Van Severen Jul 28 '12 at 18:06

score 0 · Answer 3 · answered Jul 28 '12 at 17:55

0

In the head section of the HTML page use the appropriate charset declaration like e.g.

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

answered Jul 28 '12 at 17:55

Michael Besteck

2,415
18
10

I Added this..But not working – Lahiru Chathuranga Jul 28 '12 at 17:57
Probably the data are coded in another charset than "UTF-8". This is a per document/page setting, all data in the page must conform to the declared charset. – Michael Besteck Jul 28 '12 at 18:12

Echo different languages from php

3 Answers3