Storing the '£' symbol in a mySQL table

[Rayz66]

Hello there ...

Could someone tell me how I go about storing a pound symbol in an mySQL table.

Having executed the INSERT or UPDATE command, I SELECT the row and all the pound symbols have been changed to question marks (?).

Is there a trick to do this?

Thanks in advance.

Ray

 

[sleipnir214]

What's your output medium?

If you're outputting to the web, perhaps storing it as "ampersandpoundsemicolon" (replace "ampersand" and "semicolon" with the appropriate symbols) will work. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Rayz66]

That's the thing; it's not the output to the web that's the problem.

I enter the item via the web, and when I look at the mySQL table, it's actually stored on the database as a ? character.

 

[sleipnir214]

I recommend you convert "£" to "ampersand-pound-semicolon" before you store it in the database. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!