select convert('£','US7ASCII', 'WE8MSWIN1252')
as "GBP?!",
convert('€','US7ASCII', 'WE8MSWIN1252')
as "EUR?!",
convert('¥','US7ASCII', 'WE8MSWIN1252')
as "YEN?!",
convert('$','US7ASCII', 'WE8MSWIN1252')
as "USD!"
from where_did_all_my_symbols_go;
GBP?! EUR?! YEN?! USD!
----- ----- ----- ----
A# a?? AY $
This may seem a bit of trivia, but the client will do its own conversions.
So if you have people inserting into the database with character sets,
you can find that script which worked fine in dev and test results in messed up
data when someone else runs it in production. Can cause some "interesting"
side effects if you have £, € or ¥ in your code!