473,396 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

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!
Aug 30 '07 #1
2 2144
mwasif
802 Expert 512MB
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
  1. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Aug 30 '07 #2
pbmods
5,821 Expert 4TB
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
  1. mysql_query("SET NAMES 'utf8'");
  2. mysql_query("SET CHARACTER SET 'utf8'");
  3.  
Aug 30 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: QueenArenA.com | last post by:
I have a big problems because I have to query a database which contents contains some - ' - characters and obviously the query back with errors. An example is in www.queenarena.com/turbol.php ...
8
by: Beznas | last post by:
Hi All; I'm trying to create an ASP function called CleanX that removes the punctuation and some characters like (*&^%$#@!<>?"}|{..) from a text string I came up with this but It...
1
by: Christian Schmidbauer | last post by:
Hello! I prepare my XML document like this way: ------------------------------------------------------- PrintWriter writer; Document domDocument; Element domElement; // Root tag
1
by: Mikkel Faarup | last post by:
Hi All I have run into a problem using NANT. When building with NANT and local characters like æ ø å are used in file- and method-names NANT reports an XMLParser error? VS.Net builds fine...
4
by: Carolina | last post by:
Hi! I have this C# code in a Button_Click event procedure: string FilePath = MapPath("diseño.doc"); Response.ContentType = "Application/msword"; Response.AppendHeader("content-disposition",...
8
by: santiago | last post by:
Editing XML with special characters like ç á ñ Hello. I have to code a multilanguage website. As it will be very static, I set things up so everything is loaded from an XML file. However, as...
1
by: rogoflap | last post by:
I have some regular text I export to a word document. I build this in VBA in Access and want dump it into word. I can do this, but would like to know how I can turn on an off bolding or...
3
by: ManWithNoName | last post by:
Hi! I am trying to load files that contain non-standard (and non-English) characters (e.g. µ), and need some help in understanding how the XSLT document() function interprets non-standard (and...
3
by: veer | last post by:
Hi i want to make a program on searching which works fine but when the special characters came like "ö, ä it is not seaching these characters please give some idea reGArds varinder
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.