The jury will give this string no weight

re: The jury will give this string no weight

Mike Dimmick — Tue, 18 Jan 2005 17:08:00 GMT

SQL Server 2002? I must have missed that one ;-)

I take it that SQL Server 2000 on Windows XP or Server 2003 when configured for Windows collation _will_ use the weights for the CJK Unified Ideographs extensions. I'm surprised that SQL Server collations are being extended for SQL Server 2005 - I thought they were deprecated in favour of using the OS support, remaining only for backwards compatibility reasons.

Collations can be something of a nightmare on SQL Server at times - there have been many occasions where we've developed a system and then discovered in deployment that the end customer has a different default collation. If you've not explicitly specified the collation for columns in temporary tables (which I think we now always do - I've been trying to discourage use of temporary tables), you can get collation mismatch errors. This seems to be a particular problem if one site has a SQL collation selected and the other a Windows collation - even if one is SQL_Latin1_General_CP1_CI_AS and the other Latin1_General.

I've even seen problems where Setup will select one collation if you use the Default setup options, but offer you a different default if you select a Custom install. I forget which way round it is.

re: The jury will give this string no weight

Michael Kaplan — Tue, 18 Jan 2005 17:12:00 GMT

Actually, SQL Server uses a snapshot of data prior to Windows 2000 RTM, even for Windows collations; they do not currentl use the OS.

So SQL Server 2000 will not ever give these characters weight, unless you use one of the binary collations.

I'll post more about this and the reasons for it another day.

re: The jury will give this string no weight

joe — Tue, 18 Jan 2005 17:20:00 GMT

Could you say more about getting out of the way?

I see it is in your bio as one of the aspects of your job and I always wondered what it meant. Now you hint here about it, but it seems worth some more description?

re: The jury will give this string no weight

Michael Kaplan — Tue, 18 Jan 2005 17:21:00 GMT

That is a great idea for another day, joe!

Some Tibetan strings

Michael Kaplan — Tue, 18 Jan 2005 17:23:00 GMT

I was going to include them in the original post as I said, but .Text did not like them. Here they are, just so you have them.

ཀ་ཅོག་ཞང་གསུམ།
ཀ་གཅིག་སྒོ་གཅིག་མ།
ཀ་གཅིག་ལྕམ་གང་མ།
ཀ་གཅིག་མ།
ཀ་ཆ།
ཀ་ཆུག།
ཀ་ཆེན་བཞི།
ཀ་འཇའ་ལ།
ཀ་གཉིས་པ།

:-)

Intelligent unmanaged string comparison

Sorting It All Out — Tue, 26 Apr 2005 13:32:41 GMT

If you look at the documentation for CompareString&nbsp;(but not LCMapString, though it probably ought...

A few of the gotchas of CompareString

Sorting It All Out — Thu, 05 May 2005 07:32:02 GMT

CompareString is one of the coolest APIs. I thought so even before I owned it, before I really even met...

More on sort elements

Sorting It All Out — Wed, 20 Jul 2005 11:22:33 GMT

Yesterday I contrated sort elements and text elements. I am now going to leave text elements aside for...

New in Vista Beta 1: giving more strings weight

Sorting It All Out — Mon, 08 Aug 2005 13:44:29 GMT

Back in January I put up that post entitled The jury will give this string no weight.
In that post I...

Extending collation support in SQL Server and Jet, Part 1 (the broad strokes)

Sorting It All Out — Wed, 14 Sep 2005 17:15:03 GMT

Prior posts in the series:
Extending collation support in SQL Server and Jet, Part 0 (HISTORY)
What...

Invariant vs. Ordinal, the third

Sorting It All Out — Wed, 24 May 2006 14:41:34 GMT

Mike Sheldon is one of the smartest guys I know.
You may have seen him on Channel 9 talking about Windows...

Did software developers ever learn their ABC's?

Sorting It All Out — Tue, 15 Aug 2006 14:43:52 GMT

Developers always think they are right.
Especially when they are not.
I mean, if you asked any random...

IsSortable() == false? Well, sometimes it may be lying....

Sorting It All Out — Wed, 06 Sep 2006 13:06:07 GMT

Have you ever had two different people on your team where each of them came up with a cool feature...

Why don't all the half forms sort right?

Sorting It All Out — Mon, 25 Sep 2006 11:47:22 GMT

George asked via the Contacting Me... link:

I tried to use the Unicode method of creating half...

Even the characters with no weight can be given weight in their own special way

Sorting It All Out — Sun, 19 Nov 2006 23:17:31 GMT

Coming soon to the European Union: Bulgaria and Romania! These are a couple of important events and have

The city elders won't give this string weight, either (aka On being consistently dead wrong, aka Ordinal or bust?)

Sorting It All Out — Tue, 26 Dec 2006 20:41:28 GMT

The question Richard Wilson asked me via the contact link: I am having problems with string comparisons

If you decompose those city elders, you might be able to sort them out!

Sorting It All Out — Wed, 27 Dec 2006 11:01:41 GMT

Clearly the City Elders in Athens and Sparta and Thebes and Argos, being long dead, have decomposed at

lo lo lo lo lo-LA

Sorting It All Out — Sun, 04 Feb 2007 02:01:44 GMT

Thai support has been in Windows since at least NT 4.0 (though the first version that did a really good

So how does that Naqittaut keyboard work, exactly?

Sorting It All Out — Mon, 05 Feb 2007 03:08:19 GMT

The keyboard layout for Inuktitut has a fascinating history on Windows, even though it really only dates

He had the strength of an OX[IA], I tell you

Sorting It All Out — Mon, 19 Feb 2007 03:30:11 GMT

Remember the other day when I was talking about how the jury giving the string no weight ? Well, it looks

String Indexing?

Sorting It All Out — Mon, 05 Mar 2007 02:31:29 GMT

Sometimes I see a documentation topic that bothers me a little bit. And then occasionally I'll see one

Rhymes with Amharic (a.k.a. How about a little breakfast embed, dear?)

Sorting It All Out — Sat, 14 Apr 2007 10:40:43 GMT

I have a lot of ideas for blog posts that are on my generic "to do" list. In fact, any time someone suggests

Rhymes with Amharic #4 (a.k.a. we're all [sub]set so turning out the lights and going to [em]bed!)

Sorting It All Out — Sun, 15 Apr 2007 04:45:42 GMT

(see also parts 1 , 2 , and 3 ) OK, we are getting close to the end of this little mini-series.... First

Search and ye shall find, SIAO style!

Sorting It All Out — Thu, 19 Apr 2007 20:11:29 GMT

Funny how you can discover something that changes nothing about you yet somehow makes it all look different.

Giving Yi the weight it deserves

Sorting It All Out — Mon, 30 Apr 2007 14:50:40 GMT

Bob Eaton asked over in the microsoft.public.win32.programmer.international newsgroup: I'm trying to

The exception that proves the rule that was the exception that proves another rule (aka On the variability of the Invariant)

Sorting It All Out — Sat, 12 May 2007 14:57:25 GMT

It was over two years ago that Shawn talked about how Culture data shouldn't be considered stable (except

Objection, managed code! That zero is leading!

Sorting It All Out — Sat, 02 Jun 2007 23:51:14 GMT

(Sorry about the title, my long term watching of Law and Order once again impacts the blog!) Some may

Putting the camel's nose in Building 24

Sorting It All Out — Thu, 07 Jun 2007 21:24:18 GMT

There is an old expression, usually attributed to an Arab (without citation) that goes something like:

Every character has a story #29: U+1000^H^H^H^H0f40, (TIBETAN or MYANMAR LETTER KA, depending on when you ask)

Sorting It All Out — Tue, 28 Aug 2007 10:59:52 GMT

So I was chatting with Goldie the other day and I think just after or maybe it was just before I made

A&P of Sort Keys, part 4 (aka It isn't a race but let's make an EXCEPTION and cross the Finnish line)

Sorting It All Out — Fri, 14 Sep 2007 10:31:10 GMT

Previous posts in this series: Part 0: The empty string sorts the same in every language Part 1: The

A&P of Sort Keys, part 11 (aka It's not like ideographic sorts were developed idiopathically)

Sorting It All Out — Mon, 24 Sep 2007 13:54:38 GMT

Previous posts in this series: Part 0: The empty string sorts the same in every language Part 1: The

The roadꂸ to the solution starts with identifying the actual problem.NET

Sorting It All Out — Mon, 08 Oct 2007 17:02:08 GMT

JJ's question was simple enough: Hello, This is probably not the right alias for this, but... I have

If it isn't really Tibetan, could it pinch hit for Burmese?

Sorting It All Out — Fri, 07 Dec 2007 18:35:50 GMT

After I posted Every character has a story #29: U+1000^H^H^H^H0f40, (TIBETAN or MYANMAR LETTER KA, depending

On changing the world, or at least the way people order things in it

Sorting it all Out — Sun, 16 Mar 2008 10:24:23 GMT

Please read disclaimer ; content of Michael Kaplan's blog not approved by Microsoft! You may (if you

Fight the Future? (#11 of ??), aka Microsoft is giving this character nada weight but lotsa importance

Sorting it all Out — Wed, 09 Apr 2008 10:02:20 GMT

Content of Michael Kaplan's personal blog not approved by Microsoft (see disclaimer )! Regular readers

Do we need a case insensitive binary collaton?

Collation, DateTime, SParse Column and XML — Sun, 01 Feb 2009 09:23:44 GMT

In SQL Server, the binary collation (collation name ending with BIN2) use an algorithm which directly

The road to hell is paved with attempts at being compatible

Sorting it all Out — Wed, 04 Feb 2009 11:06:05 GMT

In one of the very first blogs I wrote, I pointed out that Microsoft does not use the Unicode Collation