Sql Query

[Elton]

UPDATE Articles SET body = replace(body, 'Ã\‚£', '£');

 

Using the code above, Ã\‚£ now becomes ?, not £.

 

Anyone know why? It's in a UTF8 mysql db.

[Elton]

Had an idea - back soon

[Elton]

Balls.They show as £ in the database, but ? on screen.Any ideas?Hmmmm...Will try:£

[Elton]

UPDATE Articles SET body = replace(body, 'Ã\‚£', '£');

 

That worked.

 

Cool

[peterpikefisher]

nice one Elton you set the question and only you reply 3 times with the answer

[Andy_1984]

probably didnt work because the document coding wasnt set as utf 8, even though database is.

 

default html output will be iso

 

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

Edited November 29, 2007 by Andy_1984

[Fastd]

Are threads allowed in Latin and welsh?

 

[Norrie]

Are threads allowed in Latin and welsh?

 

 

 

Only for a doctor called Jones !!!!!