Using SQL Execution Plans to discover the Swedish alphabet

re: Using SQL Execution Plans to discover the Swedish alphabet

Simon — Mon, 03 Jan 2011 11:39:14 GMT

What happened to W?

re: Using SQL Execution Plans to discover the Swedish alphabet

Rob Farley — Mon, 03 Jan 2011 11:58:43 GMT

It's been pointed out that W is missing in my list. Wikipedia says: "Until recently the letter ‹w› was treated as a variant form of ‹v› at least for sorting purposes, and this practice is still commonly encountered."

So I guess this explains why the EndRange value following V is X.

Rob

re: Using SQL Execution Plans to discover the Swedish alphabet

kendra little — Wed, 05 Jan 2011 20:38:51 GMT

SQL Server isn't the only thing that's remarkable.

I'm not sure if this is a masterpiece, if I just learned something, or if I should be a little bit afraid.

re: Using SQL Execution Plans to discover the Swedish alphabet

KDF9 — Sun, 09 Jan 2011 23:36:50 GMT

Running SET SHOWPLAN_TEXT ON; GO; SET NOEXEC OFF; GO; SELECT col FROM dbo.collation_test where col like 'V%'; in Management Studio Express 9 gives the same results.

But with default SQL_Latin1_General_CP1_CI_AS collation, the lower bound is strangely different, and the second LIKE is needed because the seek has a >=þ, hex FE, where >hex FF would be expected:

SEEK:([MyDatabase].[dbo].[collation_test].[col] >= 'Üþ' AND [MyDatabase].[dbo].[collation_test].[col] < 'W'),

WHERE:([MyDatabase].[dbo].[collation_test].[col] like 'V%') ORDERED FORWARD)

re: Using SQL Execution Plans to discover the Swedish alphabet

Adde — Tue, 11 Jan 2011 09:43:40 GMT

W is a very rare letter in swedish, I honestly can't think of any words (apart from names and imported foreign words) that contain W.

The alphabet they teach the kids in school these days doesn't even contain W and I'm pretty sure our phonebooks and dictionaries treat V and W as the same letter orderwise.