MySQL Forums
Forum List  »  Knowledge Base

ow to remove  in the SQL database
Posted by: Norvin Whitney
Date: July 30, 2008 09:19PM

How to remove  in the SQL database
Hi after a systems crash i had to reinstall a 75 Meg sql data file form backup, a years work and happy to have the back up.
However now everywhere in the database before the £ sign as i am in the UK i have

£ I just want £

How do i get rid of the is  character in all the mails and showing before all the £ signs?
I changed the character set to

<meta http-equiv="content-type" content="text/html; charset=UTF-8" />

from
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />


but the  still shows

I see the code is &#194; for the  character

any ideas what else i can try


Any help would be appreciated.

cheers

Norvin

Options: ReplyQuote


Subject
Views
Written By
Posted
ow to remove  in the SQL database
24979
July 30, 2008 09:19PM
19092
January 29, 2009 11:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.