Jun 032013
 
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!
Get SQLfail sent to your inbox

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>