473,837 Members | 1,705 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

1 New Member
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 2165
802 Recognized Expert Contributor
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
5,821 Recognized Expert Expert
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'");
Aug 30 '07 #3

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

Similar topics

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 When the name are without those characters everything goes well but I cant menage the other one. I need to let the query see those characters in a different way.
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 doesn't look like it's working. Can anyone help please. THANK YOU.
by: Christian Schmidbauer | last post by:
Hello! I prepare my XML document like this way: ------------------------------------------------------- PrintWriter writer; Document domDocument; Element domElement; // Root tag
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 so I guess it is something with NANT parsing the project-files etc.
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", "attachment;filename=" + "dise˝o.doc"); Response.WriteFile(FilePath); Response.Flush();
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 soon as I tried to start typing in the text in spanish, french and polish, I realized that no XML editor I knew would let me type and output unicode references. I mean, I need something where I can press the ┤e sequence in the keyboard and get é...
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 underlining using special characters or combinations of these. Is this possible to build this in with my text string that is put into a word document? Where can I get a list of these types of special characters.
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 non-English) characters (e.g. Á). The problem is that I can't load files with such names. The xslt is saved and declared as UTF-8. E.g. the xml file has an Á in its name.
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
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
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, and deploymentŚwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph DuprÚ who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.