Displaying Special characters(like®) From SQL in Internet Explorer

Raju1984

If i store the string which contains special characters(®) in MySQL database ,it stores
special characters as it is. But when i try to diplay that string using HTML & queries, it shows '?' character for ® in Firefox & shows some another character in Internet Explorer.
Please try to answer that!

mwasif

Are you setting page character set to UTF-8? If not, use the following tag between <head> and </head? tags

Expand|Select|Wrap|Line Numbers

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

pbmods

Heya, Raju.

You also need to make sure that you are fetching the data as UTF-8. Try calling this when you connect to the database:

Expand|Select|Wrap|Line Numbers

 
mysql_query("SET NAMES 'utf8'");

mysql_query("SET CHARACTER SET 'utf8'");

Displaying Special characters(like®) From SQL in Internet Explorer

re: Displaying Special characters(like®) From SQL in Internet Explorer

re: Displaying Special characters(like®) From SQL in Internet Explorer

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about