Converting charictor after DB query

[the_oliver]

Hello,

 

I have a problem where text is stored in a database.  When the text is extracted via a query the £ charictor comes up as strange charictors in some browsers.  I tried

 

header("Content-Type: text/html; charset=utf-8");

 

but that just change the browsers which had the problems!

 

What i was wondering was wheter i could scearch throught the data returned from the query, and replace any £ with the html code for £?

 

Thanks

[ToonMariner]

you can (and I suggest you do it on data going IN to the database rather than on out.)

 

$str = preg_replace('/£/','$pound;',$str);

[jitesh]

instead of £ store "£" in DB

[the_oliver]

The trouble with that is that when the user goes to edit the content again they will see &pound not £.  Will try these, and see what happens.  Thanks!

[jitesh]

Need to Print like this

 

<td><?php echo "£";</td>

 

or

 

$currency = "£";

<td><?php echo $currency;</td>