Sorting it All Out: Search Archives

Search Sorting it All Out Archive

(or go back to index)

Search in posts:

Regular expressions are allowed, but play nice. Sorted descending by date published.


  1. Ignore what the label says -- it's Japanese (2008/07/03)

    …ng solution of my company. The DB is SQL Server 2000 and datasource is an ERP wish provide data in DBCS format. Default Collation is French_CI_AS on server and client machines. Stored data in varchar format appeared on this way in Enterprise Manager…

  2. Thirdly, aka Forty two, aka Understanding the answer can require a properly defined question (2008/06/30)

    …rd is roughly 42 million times more important than Calculator or WordPad/Notepad. And SQL Server's (or Access's) use of collation is roughly 56 billion (the British billion) times more important than the way files are ordered being based on the user…

  3. "I work in Windows, but for this conference I'm here for SQL Server...." (2008/06/08)

    …fascinating questions that I helped people with. In lots of areas -- e.g. database design and replication and of course collations, and a lot of interesting questions related to Unicode and Unicode data types. There were even several fans of the blo…

  4. SQL and the CLR? (2008 edition!) (2008/05/27)

    …asked via the Contact link: Last November you talked about Windows only cultures providing a potential solution for the collation differences between SQL Server and the .NET Runtime. Do you know whether this solution will be used in the upcoming ver…

  5. SQL vs. Windows collations: the tricycle versus the Porsche (2008/05/23)

    …CT * FROM #TEMP1 WHERE name ='Malteser Schlossschule' -- Results :- Malteser Schloßschule -- Malteser Schlossschule The collation of tempdb is SQL_Latin1_General_CP1_CI_AS. I'm using SQL Server 2005. --------------------------- Why does this happen?…

  6. String.StartsWith || String.EndsWith != String.Equals, either (2008/05/21)

    … Vista and later -- which is where the seemingly odd equivalences are coming from above. Since Arabic is in the default collation table, one can even test this in .NET on Vista by comparing en-US results to en-IN results, since the en-IN will go thr…

  7. Four exceptions to prove the rule (2008/05/07)

    …) rule! No other sort has this distinction, mind you. I have hinted at it blogs like The three stages of grief^H^H^H^H^Hcollation without defining it, because to be perfectly honest I do not know what the difference is (though I am reasonably certai…

  8. Much ado about zero, aka These zeroes won't ever amount to anything (2008/04/28)

    …o Insanity defined: In the real world -0 == 0, in Vista -0 < 0, and in Windows Server 2008 -0 ≮ 0 at all, or any of the collation mistakes there. And it isn't connected with Decimal Negative Zero Representation from over on the BCLTeam blog, either.…

  9. Fight the Future? (#4 of ??), aka Unicode 5.1 Unleashed! (2008/04/05)

    …code Standard has exactly the same character assignments as ISO/IEC 10646:2003 plus Amendments 1 through 4. The Unicode Collation Algorithm (UCA), the core standard for sorting all text, is also being updated at the same time (see http://www.unicode…

  10. Fight the Future? (#1 of ??), aka The inappropriate nature of getting the Feh out of Uighur (2008/04/04)

    …ed in Uighur (as it appears not to be) then some future version fo Windows could fold these two characters together for collation purposes like we did for Romanian and its comma below/cedilla characters! :-) This blog brought to you by ف and ڧ (U+06…

  11. The disunification of Norwegian and Danish sorting ( SQL Server 2008 Edition!) (2008/03/27)

    …e a 'double v'?, where I talked about the Swedish Academy's change to the way the letters W and V were to be handled in collation, and the impact on Microsoft software when this change eventually makes it to the point where it needs to be integrated…

  12. Vietnamese still ain't quite right (2008/03/26)

    …riginally reported the bug commented on the Vista behavior: Hi Michael, Not until today, I got a chance to test the new collation on Vista. It seems that those bugs have been fixed for the Unicode composite format but not for the precomposed. Moreov…

  13. Vowel "harmony", enforced by political interests? (2008/03/23)

    …ing here. After all, without the information, how can the differences that need to be captured in fonts or keyboards or collation be fully understood? Perhaps the older orthography is a 100% subset and supporting the new orthography means supporting…

  14. If we sorted Bopomofo like we do Pinyin, would it still be considered "Traditional" Chinese? (2008/03/17)

    … those other countries would probably also have to be added, too.... At this point I remind myself that I don't work on collation in Windows anymore, which does make pie-in-the-sky speculations thinking about future version support a less than usefu…

  15. Reductionizational innaccurization in acknowledmentary textual material (2008/03/17)

    …king people on the Windows 2000 team were also very helpful, both for providing information on how basic issues such as collation and locale support are supposed to work and of course for providing the original data on which SQL Server 7.0 and 2000'…

  16. On changing the world, or at least the way people order things in it (2008/03/16)

    … include it below with the emphasis on what I wanted to mention as the inspiration: That's right -- Windows Server 2008 collation support in SQL Server 2008. The feature is a line item for this diagram that helps map the features put into the next v…

  17. ঘেমন কর্ম তেমন ফল, aka Learn Bengali in a month (or not) (2008/03/03)

    …the Unicode representation shouldn't matter. As long as the higher level, user facing facilities like input, searching, collation, and rendering do reflect a user's mental model of his or her language, the underlying representation of the text shoul…

  18. On reversing the irreversible (grabbing the data, part II: the weirdness not so related to locales) (2008/03/03)

    …t worst no more awful than compressions, above), and in an upcoming blog I will explain why. You see, while much of the collation support is table-based, there are particular characters that aren't. For example there is Japanese Kana -- discussed at…

  19. The idea has to do more than just make sense to me (aka How S-Sharp are *you* feeling today?) (2008/02/24)

    …following line in CaseFolding.txt: 00DF; F; 0073 0073; # LATIN SMALL LETTER SHARP S Isn't this an error? In the Unicode collation data, there is a secondary difference between U+00DF "ß" and "ss". The way I read the Unicode Collation Algorithm, case…

  20. Despite progression, the bug calls out to me quite LAOdly (2008/02/23)

    In the early days of my ownership of the collation functionality, I did have a bit of an inferiority complex about the more linguistic aspects to the work. So I would tal…

  21. The most important language in the whole wide world is yours, and you hardly even know yours! -- NOT! (2008/02/19)

    …al to the original customer complaint that inspired this blog! There is no real "workaround", though. The update to the collation tables that happened in Vista was accompanied a major version change as well, which means such changes can be expected.…

  22. Insanity defined: In the real world -0 == 0, in Vista -0 < 0, and in Windows Server 2008 -0 ≮ 0 (2008/02/19)

    …negative zero for double type and bugs like Math functions make a distinction between 0 and -0. We even had an issue in collation, believe it or not! You see, when people are not using the whole sort digits like numbers functionality brought to you …

  23. Microsoft still does not use the UCA; the converse is also true (2008/02/10)

    …ment about them from several, even now. In the midst of all that, several comments about the DUCET (the Default Unicode Collation Element Table) came up, with people arguing that whether or not the chillu are encoded atomically impacts whether the D…

  24. Just because Microsoft does not document all the standards it works with does not mean it is uncaron (2008/02/04)

    …Georges asked the other day via the Contact link: Do you have a list of the national standards supported by the various collations that Windows and SQL Server and .NET support? And similarly, regular reader Ivan Petrov asked in the Suggestion Box: H…

  25. On reversing the irreversible (grabbing the data, part I) (2008/01/25)

    …ng this problem, people do skip), even though it means you miss out on a lot of what Windows has to offer in the way of collation support. But in many ways being willing to be flexible and work a little harder to build the data cache up will reap hu…

  26. SiaO @ B.NET (2008/01/19)

    …about that India trip.... I will be presenting an extended version of my recent Sorting It All Out - Even More Words on Collation talk that I did at the last Internationalization and Unicode Conference in San Jose, California. The extended version c…

  27. On reversing the irreversible (The Set-Up) (2008/01/14)

    … frees up the data associated with a prior InitializeSortkeyReverseData[Ex] call. Now there are some truths relating to collation that are kind of implicit in the contract that these functions will be promising -- such as: Certain locales return ide…

  28. Barack Obama sorts it all out? (2008/01/06)

    I guess we all (finally!) know how important collation is if presidential candidates are talking about it (ref: Barack Obama on Sorting Algorithms): Schmidt: What's the faste…

  29. Why my IUC31 talks were presented on Vista (even though running on a MacBook Pro) (2007/12/16)

    …to Vista. I thought I would explain why.... First we'll look at two slides on my XP SP2 machine, from the talk I did on collation. One showing the collation issues I discussed in Why don't all the half forms sort right? related to how the various fo…

  30. In SQL Server, there is the rest of Unicode (aka the SiaO Incompleteness Theorem) (2007/12/11)

    …ok fat?), now your ranges also need to ACCENT-uate the positives, how the alphabet does not end at Z, and how different collations implies different ranges (aka Not every table has its THORN). Amazingly, I have done this all while staying within the…

  31. In SQL Server, different collations implies different ranges (aka Not every table has its THORN) (2007/12/10)

    … end, the issue here is the way characters are added to the table. I talked about this in How does Microsoft assign new collation weights?, and the delicate balance between taking letters not used by the languages that use the default table between:…

  32. আজ রাত অন্নো কোন রাতের থেকে আলদা কেন? (2007/12/09)

    … actually thought the reverse alphabetical order was a lot of fun, though I have been a big champion of that particular collation in the past!) Now it isn't Passover just yet, though I figure I could maybe learn to do the questions in another of the…

  33. In SQL Server, the alphabet does not end at Z! (2007/12/09)

    …notice. :-) 2) A bunch of other miscellaneous stuff that is not needed by any of the languages that rely on the default collation table for their collation behavior. Anyway, here they all are (the five that are not in any shipping version of SQL Ser…

  34. In SQL Server, your ranges also need to ACCENT-uate the positives! (2007/12/08)

    …(aka Do my V's look fat?) That last post pointed out two characters that would be missing if you have a width sensitive collation. and now this post is going to talk about accent sensitivity and it's impact. This will add over two dozen characters l…

  35. In SQL Server, A-Z, A-z, a-Z, and a-z may not mean the same thing! (2007/12/06)

    …o, how confident are you feeling now about ranges? And now would you create an expression that would not break when the collation underneath it changed? :-) Damn. You know, this series was certainly heading toward the areas where good expressions we…

  36. In SQL Server, the distance between A and Z is wider than you might think! (2007/12/05)

    …erent results? Do you know what is going on here? Indeed I do, George. And it is an internationalization problem, and a collation one, too! If you look at the Windows table (which are slightly ahead of the SQL Server ones), there are about 1,229 let…

  37. Every character has a story #31: U+272f0 from CJK Extension B, an ideograph that proves that every rose has its thorn! (aka It wasn't my fault, but [from the Windows standpoint] it was because of me....) (2007/12/03)

    …d I was focusing on the differences between Traditional and Simplified stroke data that was being used for stroke-based collation, and wondering about the net effect in Macao (a Traditional Chinese-using region for which Microsoft uses the Simplifie…

  38. When yesterday's workaround becomes tomorrow's potential solution... (2007/11/26)

    ….NET), where I point out that the fact that SQL and the CLR both have very firmly embedded architectural notions of how collation should work that do not match (more or less just about all of them) and at time can openly disagree (e.g. a Windows-onl…

  39. Apple 3, Microsoft 0 (aka Sorting Mac and Windows all Out) (2007/11/12)

    …itivosity posts, like this other one from last week. Now even the most occasional of readers here know how I feel about collation. Hell, the blog is named with collation in mind -- not as clever of a pun as the one used by the WinFS Team Blog (i.e. …

  40. The more you understand, the more cynical you may become (2007/11/06)

    …that Yuhong Bao has been asking rather insistently, like here and via the Contact link and so on: What is the status of collation support in Access 2007? That one's easy -- the same as every prior 32-bit version with that Windows 2000 post-Beta 1, p…

  41. Microsoft is a Form 'C' shop, Part 1 (2007/10/29)

    …platforms. And a lot that support predates asnything that Unicode later chose to provide, thus we don't use the Unicode Collation Algorithm for our sorting, for years we did not use Unicode normalization for our equivalences, and all kinds of random…

  42. Not all in sync quite yet (aka SQL and the CLR and Windows and .NET) (2007/10/25)

    …mn the entries could be in English, Hebrew, Chinese and so on) and expects it to be quered from multiple cultures, what collation should one choose for the database? I guess that - to honor the "sort in locale, which user expects - the user's locale…

  43. Jokes that aren't really all that funny in the end (aka At least SQL Server isn't on our case) (2007/10/25)

    …fference affects the actual data.... It is for this reason that they have always carried their own data around for both collation and casing operations, and have since Sphinx (SQL Server 7.0) through two different collation models (Sphinx and post-S…

  44. SOL trying to change the CE UI? (2007/10/25)

    …to get support on the device you have no way to see support in a language.... That support includes font, input method, collation, locale support and so on. Without it, support of a language can be a real problem. Though I sense that Pat is not just…

  45. We weren't Vista heroes, but I think we were kinda heroic (2007/10/22)

    …make up the most significant work I did in Vista, above anything else I did related to [custom ]locales or keyboards or collation or NLS or standards or training or consulting. We were heroes because from the point of view of those languages, our me…

  46. Trying to get people to use Unicode? Lock and load, baby! (2007/10/18)

    …n for winning. On the last day he saw me just before I did my last presentation (Sorting It All Out: Even More Words on Collation) and told me he was "armed and ready." I told him "lock and load, dude." :-) The night before, I had dinner with a bunc…

  47. Trying to figure out if ǣ and a͞e would sound the same (2007/10/16)

    …ecent Contact link question was from Leb: I've been reading your blog for some time now, mostly to clean information on collation. It's good stuff! I do have a problem, however, and I was just curious if you might have any thoughts. Our group is wor…

  48. Will I C U at the I U C? Kewl! (2007/10/12)

    …e three talks that I'm doing: #1 -- Wednesday, November 17th, 2007 (16:10-17:00) Sorting It All Out: Even More Words on Collation In a properly globalized product, users will have properly collated data-e.g., in the file system, in a database, in an…

  49. Collations (SQL Compat. vs. Windows) -- not so subtle in the difference department (2007/10/10)

    …" to compare some data transformations. I got this error: Server: Msg 468, Level 16, State 9, Line 1 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. I know how to sol…

  50. A&P of Sort Keys, part 13 (About the function that is too lazy to get it right every time) (2007/10/09)

    …eturns different results than CompareString/CompareStringEx looking at the same two strings (#12 from How to track down collation bugs). And in almost every case (in fact, offhand the only exception I can recall is this bug) an objective analysis of…

  51. It looks like you are using Google anyway.... (2007/10/09)

    … Search, but due to a side effect of the way Community Server takes care of tag nesting, you know, like if you click on Collation/Casing you get this link: http://blogs.msdn.com/michkap/archive/tags/Collation_2F00_Casing/default.aspx and then if ins…

  52. Wanna take a look at the collation bug Kim pointed out? You're in for a hell of a Tripp! (2007/10/08)

    …all the stuff she has said in the past. I think the last time I linked to her was back in May 2006 (Avoiding SQL Server collation woes in the TempDB), but it was a great tip since I was doing it the hard[er] way when I really didn't need to.... The …

  53. A&P of Sort Keys, part 12 (aka Han sorts first!) (2007/10/08)

    … relate to a desire to not have Hangul to sort in with the same weight range that is shared among all of the East Asian collations (because even though Hangul does not mean much within Chinese or Japanese, it can still be unsettling if you have Hang…

  54. What's wrong with what FxCop does for globalization, Part 1 (2007/10/01)

    …d... # Michael S. Kaplan on 3 Oct 2007 12:59 AM: Fair enough, though given the security questions related to casing and collation, it is hard to say that the current shipping behavior is right (and Orcas has not RTM'ed yet, has it?)....…

  55. A&P of Sort Keys, part 11 (aka It's not like ideographic sorts were developed idiopathically) (2007/09/24)

    …t punctual and punctuating Part 10: I've kana wanted to start talking about Japanese Now that I have been talking about collation in Windows across ten separate blog posts, I thought it might make sense to talk about the characters in Unicode that t…

  56. Docs can whet SiaO's appetite, but where's the blog? (2007/09/23)

    …ck in How do I feel about lstrcmpi? I think it blows...., the Mac CFString stuff has some fascinating issues related to collation that I thought I'd chat about, with me owning a MacBook Pro and with Microsoft making Silverlight run on it and all. :-…

  57. A&P of Sort Keys, part 10 (aka I've kana wanted to start talking about Japanese) (2007/09/21)

    … the Kana are handled (but anyone could add the kana for the pronunciation in a database and that additional column for collation. This will have to do until a more intelligent type of pronunciation-based Kanji sort is given.... Also, kana sorts pro…

  58. A&P of Sort Keys, part 9 (aka Not always transitive, but punctual and punctuating) (2007/09/20)

    …itive" results, so as long as one is correct and the other is treated as a bug, they can fix it without waiting for new collations, etc. At this point, many people thinking about the fillers one sees in the DW and CW values will wonder exactly how t…

  59. A&P of Sort Keys, part 8 (aka You can often think of ignoring weights as a form of ignorance) (2007/09/18)

    …sdom I have acquired over the years I have used, worked on, owned, and then assisted with as a "developer emeritus" the collation functionality in Windows. I'm also going to take potshots at some product designs, mainly pointing at a single Microsof…

  60. A&P of Sort Keys, part 7 (aka You're very thin now, but I can still recognize you) (2007/09/17)

    …ng -- it used to (but no longer) affects the storage size, it still affects fonts if you use the same font, and affects collation in regards to the "width" piece of the sort weight. Our sample strings are just going to be plain old ASCII compared to…

  61. A&P of Sort Keys, part 6 (aka Relax, be calm, and deCOMPRESS if you are feeling out of sorts) (2007/09/16)

    … and we basically keep per unique sort COMPRESSION tables. As names go, this one is kind of unfortunate; in the Unicode Collation Algorithm they are instead called contractions, which in my opinion is a better name -- since if there is anything one …

  62. A&P of Sort Keys, part 5 (aka EXPANSIONing your horizons) (2007/09/15)

    …e different letters (in the underlying implementation it is only two, but some of them are nested so the net effect for collation is that it can be three)1. In theory the code could support even bigger nested expansions, however the nesting rules in…

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

    …en done before in Windows. But it was being done in SQL Server (then in beta, I believe) as you moved between the older collations and the newer ones, with the same potential problems (if you switched your settings to an older collation, then some c…

  64. A&P of Sort Keys, part 0 (aka The empty string sorts the same in every language) (2007/09/10)

    …clearer than we realized.... He was trying to figure out two things, essentially: Understanding the various features in collation and how each one relates to sort key size; Knowing how to apply this theoretical knowledge and actually generate the st…

  65. 2001, a Correctness Odyssey (aka What's the matter with Ü?) (2007/09/08)

    …ne workaround -- you can use U/u + combing diaresis (U+0055/U+0075 + U+0308) and they will both sort properly (in every collation except for the German phonebook sort).... # Rolf Frei on Tuesday, December 25, 2007 9:55 AM: As my application is non U…

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

    …not go by Golde; her nom de plume was Goldie) she asked me if there was a test case I knew off the top of my head where collation results changed between XP and Server 2003. Interestingly, this is a question I have been waiting years for someone to …

  67. Every character has a story #28: U+1e9e (CAPITAL SHARP S) (2007/08/24)

    …s not, and therefore does not need to be encoded. Just so. For Microsoft, it raises some interesting questions for both collation and case for the next version of Windows. I mean, think about the issues I have already talked about in posts like What…

  68. Hello Madda, Hello Father (Iranian style) (2007/08/12)

    Collation of the Arabic script in Windows has really had its ups and downs over the years. And customers tend to notice that sort…

  69. If this post really describes a bug, would I actually put it in the WYNN column? (2007/07/31)

    … since Unicode 3.0! But the Swedish tables do not put these two letters next to each other. This other letter is on our collation tables, given special weight for Turkmen (0x0442), which does not put it anywhere near the lowercase version. And our d…

  70. See that version there? It is going down, man! #1 (2007/07/30)

    …g the NLS version information to figure out when to re-index, first back in What makes a string meaningful? and then in Collation data - must be stable, but it must not stand still, I was thinking about components that worked on that version of Wind…

  71. Whether or not you're my 'type' you might see me at TypeCon 2007 (2007/07/29)

    … panel discussions, exhibitions, and special events. Now someone mentioned the other day that this blog seemed like the collationary center of the universe and I don't think his choice of words can be put down as a mere accident. In my opinion, you …

  72. No UTF-8 in a VARCHAR column (2007/07/26)

    …. Second of all, even if there were a way to make UTF-8 text work, it would not be free since the underlying engine and collation tables use UTF-16 for Unicode, there would be an associated performance hit due to the conversions. Now conversion is o…

  73. What does DAO have that ADO/ADOx/JRO do not? (2007/07/13)

    …ers here like Tony already know you are mistaken on those points. :-) I'm not an ACE fan until/unless they update their collations. Beyond that, the fact that the combination of ADO, ADOX, JRO, and the Jet OLE DB provider combined could not get thin…

  74. Upgrading the rank of the people we talk about calendars with (2007/07/06)

    …inate me. In fact, were it not for the fact that there are a few other things that capture more of my fascination (e.g. collation and linguistics), I'd actually be trying to push vision documents and architecture proposals for how I see calendars wo…

  75. Not so Lao[d], at least not until Vista (2007/07/02)

    …nguages. I really like to add Lao UNICODE but needs your help and support. I read your presentation titled 'Unicode and Collation Support in Microsoft SQL Server' which held in Prague on 23-26 March, 2003. There seems to a doable for Lao language bu…

  76. If you don't always preserve case, you don't always preserve meaning (2007/06/18)

    …ative consequences of NOT preserving case. She pointed out: Hi, I was just reading your post about the Danish/Norwegian collation sorting problems from April 27th. I am having considerable problems with the collation myself but it doesn't have anyth…

  77. año del ano, a.k.a. This sentence has several non-skarklish Spanish flutzpahs.... (2007/06/08)

    … corrupt or in some other way injure the meaning of the text. In email, people suggested ideas like looking for primary collation distinctions under the theory that collation mirrors thought and that it indicated something about the letter being tho…

  78. I Really Do Compare Strings (2007/06/03)

    …Make it sound like it's old hat GetACP, GetDateFormat But you must use Unicode Get to the center of the code Yes that's collation! An ovation! It's always a safe bet to remember the alphabet. You see, sometimes I really do compare strings! And the p…

  79. The trouble with HKSCS, for me (2007/06/03)

    …u could have filled a mailbox with the communication deciding how best to support the alternate forms in fonts! But for collation, and even for code page, thins are much less clear. I knew someone who was once joking about someone being the "least d…

  80. If a bunch of specific Unicode characters can no longer live in the same apartment together, can they really claim that they needed their space? (2007/05/17)

    …hange that happened in the new version sorting. It works like this: The space character, U+0020, is given weight in the collation table. For that matter, so do U+205f (MEDIUM MATHEMATICAL SPACE), U+3000 (IDEOGRAPHIC SPACE), U+1680 (OGHAM SPACE MARK)…

  81. The exception that proves the rule that was the exception that proves another rule (aka On the variability of the Invariant) (2007/05/12)

    …xt day with Comparison confusion: INVARIANT vs. ORDINAL. The one thing that will change between versions/platforms? The collation. It was in fact the only feature that was originally functional for the locale, and it was only later after bugs were e…

  82. All right, mistakes were made #1 (a.k.a. Expanding the EXPANSION table) (2007/05/05)

    …ld explain. I have mentioned EXPANSIONS in the past, and how you can access them directly, at least the ones in DEFAULT collation table (ref: Why doesn't FoldString take an LCID?). The way it works? Well, the DEFAULT collation table entry for these …

  83. Not everyone does the right thing for Romanian (2007/05/01)

    …ue to limitations within it, unless they were willing to go through solutions like the one I suggested in the Extending collation support series I did back in 2005. This post brought to you by Ș (U+0218, a.k.a. LATIN CAPITAL LETTER S WITH COMMA BELO…

  84. Giving Yi the weight it deserves (2007/04/30)

    …ven if they are not (e.g. (ua2d9) (ua2e0) vs. (ua2da) (ua2e0)). I presume it's because the OS (XP Pro SP2) doesn't have collation tables for Yi, but I thought I'd check if there was a work-around. Bob Sorry, Yi has no weight in any version of Window…

  85. Will the real orthography please rise? (HINT: they should all stand up) (2007/04/18)

    … language that is undergoing so many attempts at enforced change. Not to mention the detriment to industry in regard to collation, typography, or spell checking support -- technologies that will always lead to more language understanability and mutu…

  86. In case of conflict, dump the indexes! (a.k.a. A day in the life of Jet) (2007/04/17)

    …tabase Dim rs As DAO.Recordset Dim tdf As DAO.TableDef Dim idx As DAO.Index Debug.Print "Creating database with Turkish collation." Set db = DBEngine(0).CreateDatabase("test.mdb", dbLangTurkish) Debug.Print "Creating a table with one text field and …

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

    …applies to keyboards (you'll have to provide them via MSKLC or whatever), locale support (custom cultures, anyone?), or collation (currently no solution for this one, sorry -- so beware this problem!). You will probably always want to be using .NET …

  88. Rhymes with Amharic (a.k.a. How about a little breakfast embed, dear?) (2007/04/14)

    … for sure. But I know what the cost would be, so I know it is unlikely.... Given what it would break to add things like collation support downlevel, I can't say I agree (breaking active directory worldwide to enable a small market to not have to buy…

  89. The three stages of grief^H^H^H^H^Hcollation (2007/04/13)

    Just as there are stages to grief, it seems there are stages to support of collation in both product and platform.... STAGE #1: IGNORANCE (a.k.a. Denial) This first stage has one just going and doing as o…

  90. Can you really say international support is irreplaceable? (2007/04/12)

    …version, I think. Even if the string.Replace method couldn't be made consistent with the other string members involving collation support in the default case for fear of backward compatibility breaks.... This post brought to you by я (U+044f, a.k.a.…

  91. Microsoft is not uncaron^H^Hing about the issue! (2007/04/11)

    Sometimes, in order get the best results in collation, one has to use constructs that from a linguistic or a Unicode general category standpoint might seem incorrect. A good…

  92. When methods use collation to 'disturb the peace' we charge them with being 'out of sorts' (2007/04/10)

    …S instead of a TAB. In both cases, a character that is not really a combining character is treated as if it were one in collation in order to get a specific linguistically appropriate result. Which is really not a bug, though it does end up causing …

  93. I Kana understand you, could you repeater that? (Part 1) (2007/03/29)

    …tuations where one needs to display U+303b in a horizontal context (say if one is documenting its usage)? And since the collation functions do not have any kind of directionality-specific behavior and it is unclear whether one should treat the chara…

  94. A yen for Yen may be left unsatiated (2007/03/28)

    …se posts above and the one they link to even get into some of the reasons and some of the history. You can think of the collation change to make them look the same with Japanese to mean that NLS is something of an enabler here. :-( But now it looks …

  95. When language codes are reported that don't actually exist (2007/03/22)

    …lease? Thanks in advance for your help! # Michael S. Kaplan on 26 Mar 2007 4:21 AM: That is a DAO/Jet bug, due to their collation list being approximnately NINE YEARS behind Windows. Nothing to do with NLS unless one thinks the bug is supporting new…

  96. There was an order for letters, iroha was it's name-oh! (2007/03/18)

    …apanese So let's back up to the original question -- if it is used all of these places, then why is it not an alternate collation for Kana in Windows? Well, first the simple reason -- it really hasn't been requested (or, if it has, the request has n…

  97. Track change (a.k.a. A new job that has a few things in common with the old one) (2007/03/13)

    …k falling into three broad categories: A core chunk of Windows NLS and .NET internationalization, supporting most often collations and keyboard layouts but at other times pieces such as cultures and locales -- what one might call the build it all in…

  98. The search for someone who does Search correctly (2007/02/26)

    …ad thing for MANY Latin script, Cyrillic script, really any script shared between languages with different ideas on how collation ought to work. And no one seems to be able to handle the notion. worse, no one seems to even realize the notion exists.…

  99. à ≠ a (unless à = a) (2007/02/25)

    …s Microsoft Word, and obviously it can be used programmatically in both managed and unmanaged code if you call the real collation functions from the NLS API or the SystemGlobalization namespace.... This post brought to you by à (U+00e0, a.k.a. LATIN…

  100. Using a character proposal for a 'repertoire fence' extension (2007/02/24)

    …L JONGSEONG YESIEUNG-MIEUMU+11f0 U+11b7 (ᇰᆷ) For what it is worth, these same sequences are missing from the Old Hangul collation tables, as well. And none of them currently exist as Jamo containing multiple components, either. This would mean (assu…

‹‹ Previous Showing results 101—200. Next ››