Solved

echo symbols in sql

Posted on 2013-06-03
6
312 Views
Last Modified: 2013-06-03
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
0
Comment
Question by:Neil_Bradley
6 Comments
 
LVL 36

Expert Comment

by:Loganathan Natarajan
Comment Utility
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
 
LVL 48

Expert Comment

by:PortletPaul
Comment Utility
if there are turning into question marks the data probably isn't being stored as UTF8
what is your database? (and version?)
0
 
LVL 5

Author Comment

by:Neil_Bradley
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 36

Expert Comment

by:Loganathan Natarajan
Comment Utility
did you set content type like below,

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
0
 
LVL 15

Accepted Solution

by:
Jagadishwor Dulal earned 500 total points
Comment Utility
Did you try using
&reg;

Open in new window

0
 
LVL 5

Author Closing Comment

by:Neil_Bradley
Comment Utility
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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
Consider the following scenario: You are working on a website and make something great - something that lets the server work with information submitted by your users. This could be anything, from a simple guestbook to a e-Money solution. But what…
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now