[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

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 !!!
0
121doc
Asked:
121doc
2 Solutions
 
palanee83Commented:
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
 
shobinsunCommented:
Hello,

Use 'utf8_general_ci' charset in database.

hope this will help you.

Regards.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now