echo symbols in sql

Hi all,
I have a database full of strings that look like this:
company name ®  some text

When I echo the string all registered trademark symbols turn into question marks.
Apart from converting the symbols into "©", does anyone have any ideas how to remedy this?
Cheers,
N
LVL 5
Neil_BradleyWeb UX/UI DeveloperAsked:
Who is Participating?
 
Jagadishwor DulalConnect With a Mentor Braces MediaCommented:
Did you try using
®

Open in new window

0
 
Loganathan NatarajanLAMP DeveloperCommented:
How it looks in db table text filed? Is it like question marks way stored or it is right way?
If so, you set some encoding type and display?
0
 
PortletPaulfreelancerCommented:
if there are turning into question marks the data probably isn't being stored as UTF8
what is your database? (and version?)
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Neil_BradleyWeb UX/UI DeveloperAuthor Commented:
To answer both questions.
Yes, the symbols are showing up fine in the database (they look like this ® ).

Database info:
•Software: MySQL
•Software version: 5.0.96-community - MySQL Community Edition (GPL)
•Protocol version: 10
• Server charset:  UTF-8 Unicode (utf8)
0
 
Loganathan NatarajanLAMP DeveloperCommented:
did you set content type like below,

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
0
 
Neil_BradleyWeb UX/UI DeveloperAuthor Commented:
That worked perfectly! Thank you.

I  checked and this "<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />" was in place.
Cheers,
Neil
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.