(or go back to index)
Unicode 5.0 -- the beta! (2005/12/13)
…om Unicode.org and run their existing scripts to process those files into their internal data formats. This happens for collation, case-compression and similar algorithms. In the past there have been big changes like the introduction of characters o…
Perhaps not the best person? (2005/12/09)
… stop now) # Stuart Ballard on 9 Dec 2005 10:06 PM: Well, you've singlehandedly got me, for one, to care about i18n and collations and stuff. Ok, to be completely honest, I don't care a *huge* amount about it (our app would almost certainly fall dow…
Some sorts resist the future (2005/12/07)
… is a way for us to tell any smart callers to expect there to be a change. (I talked about that mechanism in posts like Collation data -- must be stable, but it must not stand still.) On the other hand, we cannot assume that every single caller will…
Expectations around collation (2005/11/30)
… sorting versus Dutch sorting. It was at first kind of amusing to me since all three of those languages use the default collation table, so it seemed funny to talk about conflicting expectations when all three would sort the same way on Windows. :-)…
SQL Server's cultural sensitivities (2005/11/29)
…ramework, and just in case the question being asked of me was in reference to whether SQL Server 2005 supports the same collations as the .NET Framework, you will want to take a look at posts of mine like String.Compare is for sissies (not for peopl…
Technically it *is* a hungarian sort (2005/11/26)
… is even more complicated than I thought I talked about an additional interesting wrinkle in this particular language's collation. There were some interesting comments in that post, like this one: I tell you a story. I had a strange error on MS SQL …
More on the fabled EqualString (2005/11/22)
…ck of a companion function to CompareString that tested for equality kept a particular (uncommon?) feature in Hungarian collation from being supported. But the thing that has generated the most email was neither the issues related to German nor the …
29th Internationalization and Unicode Conference (2005/11/21)
…ce is right here. There are two presentations I will be doing at the conference: Sorting it all Out: An Introduction to Collation Tales of Incorrect String Comparisons Though admittedly I may be lobbying them to reverse the ordering (they have the i…
Some sort of order to collation (2005/11/18)
…at might be worth a little discussion. :-) I remember Cathy and I doing a presentation a while back for the group about collation (similar to the ones we did at IUC22 and IUC23) and we talked about how to someone speaking English or German Å comes a…
ISO 8601 is asinine (2005/11/14)
…the Swedish preferences and people blindly followed the "standard", instead. Its like that attempt to build a "European collation" that surfaces every few years.... as if it would really help people to make them change the alphabet they have known s…
Which comes first, 'a' or 'A' ? (2005/11/13)
…gs in a blog post. :-) Here goes.... The concept of alphabetic case is interesting. And so is the concept of linguistic collation. So let's juxtapose those two concepts for a moment. Which comes first -- uppercase or lowercase? Well, in a binary sor…
Hungarian is even more complicated than I thought (2005/11/13)
…onal EqualString function to give the linguistic absolute equality question while still giving the different answer for collation. And the behavior of EqualString would almost always be identical to the behavior of CompareString returning CSTR_EQUAL…
Any Sami speakers reading this blog? :-) (2005/11/11)
…there and willing to answer.... :-) When the Sami locales were added in Windows XP SP2, there was no information of the collation used by any of the nine. It seemed to be more sensible to at least use the Norwegien, Swedish, and Finnish collations f…
SQL Compatibility collations are a bit too retro for me (2005/11/08)
Now when I say that 'SQL Compatibility collations are a bit too retro for me' I mean retro in the sense of retrograde.... Last month, Richard asked me: Still working on…
SQL Server and the CLR have different ways of getting the money (2005/11/07)
…QL Server is doing, myself. :-) The problem here is a different one than was posted to talk about SQLCLR consistency in collation, entitled String.Compare is for sissies (not for people who want SQLCLR consistency). But in a way it is much more insi…
My own personal thoughts about collation in the Mono project (2005/11/03)
…hings stick out, I worked through a few of the problems that Atsushi Eno had reported about in his own investigation of collation for the Mono implementation, when looking at results in ours. Shortly after that, this post went up, which describes th…
I WON to talk about the YEN (2005/11/01)
…s solved. Now we have some of the tools in place to help here: As I pointed out here and here, both Japanese and Korean collations on Windows will equate the two, thus assuring us that people using the characters as currency signs will not be punish…
Why an 8-hour day seems to take forever (2005/10/29)
…: Hello, Michael. About U+221E. I test this code in SQL Server 2005. select convert(varchar, nchar(0x221E)) Result: '8' Collation(Latin1_General_CI_AS). '∞' Collation(Japanese_CI_AS). Why U+221E is convert to 8 in Latin1_General_CI_AS ? The answer c…
For those who enjoy mathematics (or, 'Also new in Vista') (2005/10/25)
…ual semantic meaning that is expressed in symbols an variables that have such attributes. At that point, thinking about collation, I asked him if there was ever a time that it would be interesting or important to fold those differences together, for…
Searching for supplementary characters (2005/10/24)
…alled fonts etc.) of the system that created it. What a headache. # Nick Lamb on 24 Oct 2005 5:53 AM: Also, I wonder if collation order is available for these characters anyway? The original questioner seems to assume, perhaps rather naively, that t…
Extending collation support in SQL Server and Jet, Part 4 (What about Jet?) (2005/10/21)
Prior posts in this series: Extending collation support in SQL Server and Jet, Part 0 (HISTORY) Extending collation support in SQL Server and Jet, Part 1 (the broad st…
Searching encoded strings in SQL Server 2000? (2005/10/13)
…s. # Maurits [MSFT] on 13 Oct 2005 6:04 PM: nvarchar is always UTF-16, right? And varchar encoding is determined by the collation options for the server, database, table, or column (level of granularity differing by SQL Server version)? But if you w…
Extending collation support in SQL Server and Jet, Part 3 (THAT CLASS) (2005/10/09)
Prior posts in this series: Extending collation support in SQL Server and Jet, Part 0 (HISTORY) Extending collation support in SQL Server and Jet, Part 1 (the broad st…
How to track down collation bugs (2005/10/05)
… I am working on while I am working on it. And over the past few days I have been clearing out a bunch of small bugs in collation edge cases, the earliest of which was reported back in 2001. It occurred to me that there is a pattern I can use to nar…
FAT/FAT32 oddness on Win2000 (2005/09/28)
…e) on these drives and I have no problems at all. So this is not just a simple code page issue. It is also not a simple collation being used incorrectly issue, since these two characters are not considered equal there, either. Luckily it also does n…
Extending collation support in SQL Server and Jet, Part 2.1 (is this on?) (2005/09/25)
Ok, I am now three posts into this series: Extending collation support in SQL Server and Jet, Part 0 (HISTORY) Extending collation support in SQL Server and Jet, Part 1 (the broad st…
Extending collation support in SQL Server and Jet, Part 2 (generating sort keys) (2005/09/18)
Prior posts in the series: Extending collation support in SQL Server and Jet, Part 0 (HISTORY) Extending collation support in SQL Server and Jet, Part 1 (the broad st…
Extending collation support in SQL Server and Jet, Part 1 (the broad strokes) (2005/09/14)
Prior posts in the series: Extending collation support in SQL Server and Jet, Part 0 (HISTORY) What makes this problem so much easier in the soon to be released Yukon…
One more thing about Korean.... (2005/09/14)
… to re-encode that they would desire to emulate), which in turn was one of the forces that keeps the two forms that our collation does work to support separate. But his text does apply to Unicode in general, and was quite interesting, so I will repo…
Here is an interview question for you. :-) (2005/09/13)
…dy. set. Go! # Shaun Bedingfield on Tuesday, September 13, 2005 10:12 PM: What language? Which sort order? (Sql Server: collation?) When people ask you to do anything, the best response is usually a question. ie. If someone asks you how to compress …
Extending collation support in SQL Server and Jet, Part 0 (HISTORY) (2005/09/13)
… some time back in late 90s. Folks on the Microsoft Jet [red] team were really worried about the Jet reliance on the OS collation functions for CJK sorts, since they would give different results across several of the different supported versions of …
Theory vs. practice for Korean text collation, Redux (2005/09/12)
Back in February, I talked about theory vs. practice for Korean text collation, comparing Microsoft's implementation of old Hangul versus the one specified by Unicode (which uses normalization to mo…
How does Microsoft assign new collation weights? (2005/09/12)
…guists who does much of the actual work of reverse engineering dictionaries and sorted word lists to determine what the collations are, I do work with them and have been the one checkin in a lot of their work and the code that makes use of it. Plus …
Vietnamese is a complex language on Windows (2005/08/27)
Back in May of 2004, Quan Nguyen sent a message to Dr. International about Vietnamese collation in Windows and the .NET Framework: I tried to sort Vietnamese characters according to Vietnamese collation rules, as pr…
What the hell does HTTP_ACCEPT_LANGUAGE mean? (2005/08/23)
…nding information from their browser, and could mean any of the following things: language/locale to use for formatting/collation preferences language/locale to use for the UI language/locale about which to provide content location for which to prov…
What if my strings are > 2 gb? (2005/08/23)
…risons on strings that are greater than 2 GB in size. There is simply no way to justify this is a reasonable use of the collation functionality in NLS API. Perhaps some of you may disagree with this notion, and I'll be curious how people respond to …
International support as a developer 'tax' ? (2005/08/22)
…wondered if in those situations support for internationalization (which is not just multilingual but also proper locale/collation support, etc.) would be considered a "tax". After all if you only ever ship to one small place that speaks one language…
New in Vista Beta 1: Updated OS casing tables (2005/08/20)
…trings weight, where I explained about how in Vista we are adding all of the assigned code points in Unicode 4.1 to the collation tables. Well, there is another set of tables that needed such an update -- tables that have not been updated in a long …
Double compressions -- Hungarian goulash? (2005/08/10)
…e treated as equivalent to dzsdzs. Now this is an important issue on two levels -- basically dealing with the fact that collation deals with both comparison and ordering. I'll talk about both aspects now. COMPARISON -- In Hungarian comparisons, havi…
The further you look into it, the further things stick out (2005/08/03)
This line from a David Byrne song has a lot of truth in it and it could be applied well to collation. :-) Just recently I was reading some posts from ものがたり (diary for AtsushiEno), specifically from June 17th of this year…
New in Vista Beta 1: more use of the word 'linguistic' (2005/08/02)
…zation coming out soon that is probably going to be well over 500 pages, only 5-6 of which are about my favorite topic (collation), which managed to split collation and string comparison into two different topics and spend two pages talking about al…
Why do the high surrogates have the low numbers? (2005/07/31)
… way human beings try to equate what we understand to what we do not. I remember trying to explain to someone about our collation weighing system, and the way we gave the items that come earlier 'less weight' so that they come first. He was confused…
There is no such thing as a surrogate character (dammit!) (2005/07/27)
…ither the high or low character is missing) is not supported.". I do mind the not-entirely-accurate statement about the collation, but I will talk about that another day! I do not mind the surrogate character usage like that in the previous paragrap…
A subkultur iz a shprakh mit an armey un a flot (2005/07/25)
…- Shtetl (Hebrew) to account for the fact that both scripts are used in these times. And the question of what to do wih collation is a fascinating one for the Latin script (though fairly obvious for the Hebrew script one). Thus my modified quote, to…
The ideographic 'myth' ? Well... (2005/07/22)
… not wish to buy the arguments I'll put forward. My expertise is in this case definitely more toward implementations of collation that look at the script across various languages. And comparing it against many languages that use other scripts such a…
More on sort elements (2005/07/20)
… I contrated sort elements and text elements. I am now going to leave text elements aside for a bit. Because linguistic collation on Windows, at its heart, is an ordering based on sort elements, not text elements. Every time I look at the text in th…
Sort element vs. text element (2005/07/19)
…mes it is not (a good example of one that is not would be the Traditional Spanish "ch"). Sort elements are the basis of collation support on Windows and since there is no function or method that specifically enumerates them, they are usually thought…
A Microsoft convention for compressions in sorting (2005/07/17)
The other day, a developer named Stephanie sent me an email about compressions (these are used in collation when two or more characters are given a single sort weight -- the Unicode Collation Algorithm calls their analagous con…
Don't roll your own CompareString... uh... never mind (2005/07/15)
…ail to pick up the right support for genitive dates, an important functionality in several locales. Everyone knows that collation is what I like best, so I wanted to write that you should not try to do the same sort of thing with CompareString. But …
Why doesn't FoldString take an LCID? (2005/07/09)
… ligature 'æ' expands to the two characters 'a' and 'e'. And this flag works by consulting the very same table that the collation functions use to find these characters that expand. Generally this will all work. EXCEPT there are many languages (for …
Coming soon (2005/07/06)
When I showed the differences between the CLR and Yukon collation support in this post, I definitely left a lot of assembly required. I will soon be posting more direct samples to help …
'Need more input, Stephanie!' (2005/07/05)
…QL Authentication, where USERs and GROUPs are created within SQL Server. Validation of logons is done with SQL Server's collation mechanisms, using the SERVER collation setting (not the database). There are no specific functions one can call from Wi…
The road to Amsterdam is paved with.... (2005/07/03)
…h, 12:00 -- 13:15 DAT319: Databases for the World: Best Practices for Search in Multilingual Data Sets Using SQL Server Collation for Sorting and Indexing Wednesday, July 6th 16:30 -- 17:45 Also, I am scheduled in the "Ask the Experts" area, located…
Query collation source data? (2005/06/30)
…bit of serendipity. :-) The quick answer: You can't. The fast paced answer that is a bit less of a sprint: Although the collation tables for the various CJK languages are based on source data that has the various pronunciations and stroke counts, th…
Update on Community Server issues that seem to affect this blog (2005/06/29)
…appens, though it is slightly different now: Search http://blogs.msdn.com/michkap/ for a word that is there a lot, like collation. It is now up to 57 hits (but after all, the name of the freaking blog is "Sorting It All Out"; what did you expect?). …
The 'grammar' of identifiers (2005/06/28)
…chine names and identiers in programming languages and such. The former might be possible (Active Directory uses us for collation after all), but the latter is of course a pipedream, since programming languages that allow attrocities like this will …
LCMapString's *other* job (2005/06/24)
…mples (in my speak). # Michael S. Kaplan on 25 Jun 2005 10:15 PM: Actually, we are not a 100% normalization shop in our collation (a fact about which I have posted before). ZBut even if we were, we would only deal with NFC and NFD -- NFKC and NFKD a…
More on locales in SQL Server (2005/06/16)
…y previously). The interesting idea (in my opinion) is that they do not try to keep the CRT locale in sync with the SQL collation setting. Which in a way makes sense; after all, which would they choose to be similar to? The server's? Kind of useless…
Once more into the palindrome (2005/06/15)
… a sort key, though the sort key obviously contains the information about when these compressions (known in the Unicode Collation Algorithm as 'contractions'). I stewed on this for a bit today, after finally deciding to tackle this post. There had t…
A syllabary does not need to be encoded as one (2005/06/13)
…than it should be surprising that a Swedish user might wish to have U+00e5 (å) moved to be after the letter "Z" to make collation easier. But that is because in both cases the user is naively assuming that it is the job of the encoding philosophy an…
Browsing the shoals of managed string comparisons (2005/06/12)
…ck to a kinder, gentler time. ... If the MS C Runtime library support for the strxfrm() function took into account sort collation, eg. dictionary vs. phonebook in some locales, then all things collapse onto themselves and the handy strcmp() wins the…
Is it Macau or is it Macao? (2005/06/11)
…ite, and not just because they have updated more recently. :-) Last year, while looking into what we had for East Asian collation support in Windows, I noticed a curious fact. The default system code page is 950, which is the Traditional Chinese cod…
'Just to see the heads explode would be very cool,' he said (2005/06/09)
…en pop by and see DBA319 (Databases for the World: Best Practices for Search in Multilingual Data Sets Using SQL Server Collation for Sorting and Indexing) in N210 B from 2:45pm to 4:00pm.... no comments…
String.Compare is for sissies (not for people who want SQLCLR consistency) (2005/06/09)
…in mind, they will become important soon. In both Shiloh (SQL Server 2000) and Yukon (SQL Server 2005), the very useful COLLATIONPROPERTY has two very cool attributes you can grab: LCID -- returns the LCID you would use in Windows ComparisonStyle --…
TechEd Orlando: Day 2 (2005/06/08)
…k on 8 Jun 2005 1:33 PM: Speaking of SQL Server and Unicode, some of the documentation seems to imply that with Windows collations, a conversion from byte-oriented character set to Unicode occurs before comparison. Is this actually true? I guess a w…
'desire to deeply understand core globalization features at their lowest levels' (2005/06/06)
…at I can help shape based on my knowledge of what the functions and functionality do now. I am especially interested in collation (as many have gathered!), and many fascinating aspects of the issues and benefits of both getting out of the way and op…
Does Bengali sorting work? (2005/06/05)
…f that support is in there. There are even easy things to check for, like the Hasant and its expected effect on Bengali collation. Unfortunately, the joy by which one can be happy at how easy is to verify is quickly dashed by the results of calls to…
Another one black and blue at Tech Ed Orlando (2005/06/03)
…r. International's Clinic 02:45pm - 04:00pm DBA319: Best Practices for Search in Multilingual Datasets Using SQL Server Collation and Indexing And the rest of the time I will be attending other people's sessions or BOFs or GrokTalks or hooking up wi…
Knock knock! Who's there? Kana! Kana Who? (2005/06/01)
…how we order Japanese strings? :-) Some time yesterday, one of the testers over on the Shell team was curious about how collation works for the Japanese alphabet. The discussion was an interesting one, so I thought I would post the summary of all th…
Hats off to David Beaver (2005/05/30)
…tion related to the use of diacritics or even just the plain words is really quite fascinating. Knowing what I do about collation and indexes, I could spend a lot of time in this area, trying to reverse engineer both the alogorithm and the indexes b…
Encoding scheme, encoding form, or other (2005/05/24)
…ing Unicode in order to provide an ASCII-compatible 8-bit encoding that is similar to UTF-8 but preserves UTF-16 binary collation. It is not intended nor recommended as an encoding used for open information exchange. The Unicode Consortium, does not…
The string is freaking empty! (2005/05/19)
Not too long ago, we picked up a new tester (new to the area, not to testing in general) to own collation for Windows and the .NET Framework. Now I will readily admit that is usually news that I take as well as getting a new …
No data loss (as long as it is Unicode data) (2005/05/18)
A few days ago, I made some SQL server developers nervous when I explained that Not all SQL Server collations are created equal. But there is one point I must emphasize here. There is no data loss in moving between collations, a…
Time/Date change for one of my TechEd 2005 talks (2005/05/17)
…lk is happening at the same time as before: DBA319 Best Practices for Search in Multilingual Data Sets Using SQL Server Collation for Sorting and Indexing Unchanged time: Thursday, June 9 10:15 AM - 11:30 AM For what it is worth, I will be manning D…
Not all SQL Server collations are created equal (2005/05/15)
Not all of the collations in SQL Server 2005 (a.k.a. Yukon) and earlier versions have coverage over the same full sets of Unicode code points. (…
Dealing with backcompat across many versions (2005/05/11)
…- their users must deal with that; Other things can and might change in any version (like updated Unicode properties or collation values) -- their users must deal with that as well; Still other things change which were not anticipated but there is a…
Case/kana/accent/width sensitive SQL Server, for testing (2005/05/11)
…sitive in an expression in SQL Server. Now looking beyond the issue with that one expression, and to the wider issue of collations and what to use, for just a moment.... (This post contains several topics I will be covering in my TechEd 2005 talks i…
Achieving case insensitivity (2005/05/11)
…up, they missed this other one!) Now the easiest way to do a case sensitive sort on a column is to use a case-sensitive collation, like with this query: SELECT * FROM Customers ORDER BY TeritoryCode COLLATE Latin1_General_CS_AS or something similar.…
Raymond's Chinese dictionary (2005/05/10)
…h is related to my prior blather about how IMEs have it easy. Dictionaries have some of the same conundrums as we do in collation, depending on what they do with words that use the same ideograph but have different pronunciations.... Anyway, in toda…
Making SQL Server index usage a bit more deterministic (2005/05/06)
… the SQL Server International team (and several people on the Engine and at least one architect!): Issues with defining collation at the column level How often would you have a database that needs one sort order (for example, Latin1_General) and a c…
Community Server issues that seem affect this blog (2005/05/05)
…arch results are unavailable. Ok, go to http://blogs.msdn.com/michkap/ and search for a topic with a lot of hits, like "collation". Results: 46 hits. Ok, I like collation. :-) Page 1: http://blogs.msdn.com/michkap/search.aspx?q=Collation&p=1 At the …
A few of the gotchas of CompareString (2005/05/05)
…w for actual usage, the intent is clear: through the use of meaningful strings that have defined weights in the Windows collation tables, developers have the opportunity to get back linguistically appropriate results. When you veer outside of this r…
Collation data -- must be stable, but it must not stand still (2005/05/04)
…s deal with the repercussions of that happening between versions? The key is that an application cannot assume that the collation data may never change. Because the truth is that it may, and it has. But an application has a choice here -- rather tha…
The Architect (apologies to 'The Matrix Reloaded') (2005/05/03)
…experienced this in a very general way, your experience is far more specific. Vis-a-vis the feature you are so fond of, collation. *Images of Ballmer fighting a faceless black suited person from Boca-Raton appear on the monitors* Michael - Ballmer. …
Normalization vs. .NET text elements (2005/04/30)
…a very interesting problem develops since there is really not an easy method for detecting such cases given the current collation function set (although I can imagine a few avenues of attack and we obviously have the underlying data if we had to sup…
Instead of a 'blue screen', I am waiting for the blue screen (2005/04/15)
…g about how I see blue screens all the time. Part of my job is to do some of the data updates in Windows, mostly to the collation bits. I am pretty much the person who authors all of the data changes that require no linguistic talent and I am the pe…
What the %#$* is wrong with German sorting? (2005/04/10)
…urn "SS". (for more info on those casing rules, see CaseFolding.txt in the Unicode Character Database) But in any case, collation can be a bit more flexible. Since the Sharp S is very much a German letter and not one widely used outside of German, i…
And then there is the virama.... (2005/04/09)
…ndic letter contains. I was very pleased once I understood this concept (I was dealing with Tamil at the time). And the collation rules also seemed quite intuitive to me -- a letter with its inherent vowel surpressed comes before that same letter th…
The ever-misleadingly incorrect usage of the word DEFAULT (2005/04/08)
…tive behavior fails, we do not fall back to US English -- we fail the API. For us, the "default" table that is used for collation (one of the few appropriate uses for the word!) supports over 70 different locales and their expected results. So you c…
I will be at TechEd Europe (July 5-8) (2005/04/07)
… it is our target database for the next version and right now change is easy. This reminds me we must submit our binary collation sequence bug (minor difference between 2K & 2K5) Failing that fancy doing TechEd Amsterdam? Well, turns out I will be i…
Two Birds of a Feather Sessions proposed for TechEd 2005 (2005/04/04)
… the sessions can do so at BOF Voting. The sessions I proposed are entitled: Security and Unicode on Microsoft products Collation and Security -- The Problems No One Noticed If you are attending and believe either or both of them would hold interest…
TechEd Bloggers does not work for this site? (2005/04/03)
…t pick it up.... After a huge recent stir here, I was even going to do a Birds of a Feather proposal about security and collation (or the evil that developers do with invariant comparisons), but I am not sure if that is something that speakers (or M…
Session info available on the TechEd site! (June 5-10) (2005/03/31)
… good use of them. DBA319 Databases for the World: Best Practices for Search in Multilingual Data Sets Using SQL Server Collation for Sorting and Indexing Thursday, June 9 10:15 AM - 11:30 AM --> Speaker(s): Michael Kaplan Session Type(s): Breakout …
What does the the third letter in GIFT stand for? (2005/03/30)
… goes wrong. But their work is no less important, in fact I would argue it is often more important since the utility of collation and casing and encoding is pretty limited if you can't see what the characters are (only people on the NLS team get goo…
The WinForms DateTimePicker and MonthCalendar do not support culture settings (2005/03/28)
…globalized, it would never be based on the UI settings. This is because the date, time, calendar, number, currency, and collation settings are always based on the default user locale (and on CurrentCulture in the .NET Framework). If a localized appl…
Session info available on the TechEd site! (2005/03/27)
… good use of them. DBA319 Databases for the World: Best Practices for Search in Multilingual Data Sets Using SQL Server Collation for Sorting and Indexing Thursday, June 9 10:15 AM - 11:30 AM --> Speaker(s): Michael Kaplan Session Type(s): Breakout …
IStemmer'ed the tide (or, Language-specific processing #2) (2005/03/13)
…that I'll talk about other issues that exist here. It is a rich area.:-) 1 - Also, I am proud to be the "data owner" of collation of some of the languages that require no linguistic aptitude whatsoever. And I am the one behind the "teaching the comp…
When good SQL queries have trouble.... (2005/03/11)
…e21 (THAI CHARACTER MO MA) The SQL Server 2000 database, being one that contains lots of Thai data, uses the Thai_CS_AS collation. Looking at the queries, they are basically an attempt to see if the third string can be found within the first two. Sh…
Dere are qvestions? In zat case... (2005/03/10)
… at what is known as the German Phonebook Sort -- LCID of 0x00010407. It will have all of the following equivalences in collation: Ä == AE ä == ae Ö == OE ö == oe Ü == UE ü == ue You can just think of collation as the technology that will travel to …
Before you find, or search, you have to *index* (or, Language-specific processing #0) (2005/03/08)
…onal program manager of SQL Server. One of the architects in the group had written a multiple page email describing the collation support in SQL Server 2000, and the PM wanted to include some more information about other parts of the SQL Server prod…
‹‹ Previous Showing results 301—400. Next ››