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" />

<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.



Options: ReplyQuote

Written By
ow to remove  in the SQL database
July 30, 2008 09:19PM
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.