PHP Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Programming Languages > PHP Development
Reload this Page

Can't get PHP/MySQL to display degree symbol or ± --- shows question mark

The ASP Free website provides in-depth information on the latest developer tools available from Microsoft. Our cadre of writers, highly experienced industry experts, reveals the best ways to use established technologies as well as new and emerging technologies. Our coverage of Microsoft's development and administration technologies is among the most respected in the IT industry today.

ASP Free and Iron Speed Designer are giving away $5,500+ in FREE licenses. Iron Speed's RAD CASE toolset can save up to 80% of your coding time. One free license per week, one perpetual license per month!
Download and Activate to enter!

Intel® Graphics Performance Analyzers is a powerful tool suite for analyzing and optimizing your games, media, and graphics-intensive applications. Used by some of the best developers on the planet, Intel GPA lets you maximize your app’s performance.

Tutorials | Forums

Download to Enter | Contest Rules
DOWNLOAD INTEL® GPA FOR FREE

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old August 1st, 2007, 09:41 PM
james555 james555 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Posts: 292 james555 New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: 1 Day 19 h 2 m 9 sec
Reputation Power: 0
Can't get PHP/MySQL to display degree symbol or ± --- shows question mark
Is there a quick way to parse the mysql data so that degree symbols and this symbol ± shows up correctly in the display. Right now it shows those symbols as question marks (?) even though I can see them ok in the PHPMyAdmin view of the table.

I have this in my HTML/php code already:

PHP Code:
<META http-equiv="Content-Type" content="text/html; charset=UTF-8"> 




Anything else I can try?
Reply With Quote
  #2  
Old August 1st, 2007, 09:53 PM
crackster crackster is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2005
Location: Maine,USA Munich,Germany
Posts: 260 crackster User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 Days 11 h 51 m 50 sec
Reputation Power: 7
try using the html version of the two symbols.
just remove spaces.
for degree
Code:
& d e g ; or ° & # 1 7 6 ;


for plus minus
Code:
& p l u s m n ; or ± & # 1 7 7 ;
__________________

My Blog
Reply With Quote
  #3  
Old August 1st, 2007, 09:58 PM
james555 james555 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Posts: 292 james555 New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: 1 Day 19 h 2 m 9 sec
Reputation Power: 0
Quote:
Originally Posted by crackster
try using the html version of the two symbols.
just remove spaces.
for degree
Code:
& d e g ; or ° & # 1 7 6 ;


for plus minus
Code:
& p l u s m n ; or ± & # 1 7 7 ;


They are already entered in a bunch of rows & fields in the database.... so I should just do a replace on each of the fields perhaps? Is there another more global fix? I'm worried other symbols will have problems as well.

For now I can manually trap/replace these two I suppose.

And they show up ok in PHPMyAdmin... what are they doing different in their code?
Last edited by james555 : August 1st, 2007 at 10:01 PM.
Reply With Quote
  #4  
Old August 1st, 2007, 10:21 PM
james555 james555 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Posts: 292 james555 New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: 1 Day 19 h 2 m 9 sec
Reputation Power: 0
found a quick fix... just needed to add this to the top of my page:

PHP Code:
 header('Content-type: text/html; charset=iso-8859-1'); 
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages > PHP Development > Can't get PHP/MySQL to display degree symbol or ± --- shows question mark

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.

© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 10 - Follow our Sitemap