Problem with Storing Language Text in Database then displaying in browser.

Hello,

I have one multi-language website in which I'm storing language content/text in Database as filed as TEXT field type.

I'm facing problem with different language char.

Like for french / spanish have some special char on their language , once we store this in DB and then we fetch from DB by php script and it get displayed in browser via php file.

But when we view that page from browser its showing converted those char in another some special char and all mixed up.

i think its related to char set problem

Can any advice how exactly i should store all this value in DB so this problem can avoid.

Many Thanks in Advance !!!
121docAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
palanee83Connect With a Mentor Commented:
Hi,

You can set UTF-8 char-set for DB.

Explore the below URL to know more about char-set


http://dev.mysql.com/doc/refman/5.0/en/charset.html
0
 
shobinsunConnect With a Mentor Commented:
Hello,

Use 'utf8_general_ci' charset in database.

hope this will help you.

Regards.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.