SQLBits - Unicode Porn
Posted
by Most Valuable Yak (Rob Volk)
on SQL Team
See other posts from SQL Team
or by Most Valuable Yak (Rob Volk)
Published on Sat, 31 Mar 2012 16:25:28 GMT
Indexed on
2012/03/31
17:36 UTC
Read the original article
Hit count: 606
Filed under:
We've just finished up a fantastic event at SQLBits X in London! If you've never been to SQLBits and you can make it to the UK, I highly recommend it. If you didn't attend, here's what you missed.
Meanwhile, for those who attended the Lightning Talk sessions and were disappointed that I ran out of time, here's the last part that you would have seen:
/* How to Lose Friends and Irritate People...With Unicode!
Rob Volk
SQLBits X - London - March 31, 2012
*/
-- some sexy SQL
DECLARE @oohbaby TABLE(i INT NOT NULL UNIQUE,
uni_char AS NCHAR(i),
hex AS CAST(i AS BINARY(2)))
INSERT @oohbaby VALUES(664),(1022),(1023),(1120),(1150),(8857),(11609),(42420),(42427)
-- change results font to larger size, some only work in grid font
SELECT * FROM @oohbaby
SELECT NCHAR(1022) + NCHAR(1023) AS Page3Girl
It's probably better that you run this yourself, in the privacy of your own home/office, you know *wink* *wink* *nudge* *nudge* *say no more*
Meanwhile, for those who attended the Lightning Talk sessions and were disappointed that I ran out of time, here's the last part that you would have seen:
/* How to Lose Friends and Irritate People...With Unicode!
Rob Volk
SQLBits X - London - March 31, 2012
*/
-- some sexy SQL
DECLARE @oohbaby TABLE(i INT NOT NULL UNIQUE,
uni_char AS NCHAR(i),
hex AS CAST(i AS BINARY(2)))
INSERT @oohbaby VALUES(664),(1022),(1023),(1120),(1150),(8857),(11609),(42420),(42427)
-- change results font to larger size, some only work in grid font
SELECT * FROM @oohbaby
SELECT NCHAR(1022) + NCHAR(1023) AS Page3Girl
It's probably better that you run this yourself, in the privacy of your own home/office, you know *wink* *wink* *nudge* *nudge* *say no more*
© SQL Team or respective owner
