Home Forums Article Discussions Article Discussions by Author Discuss content posted by Tom Thomson character ordering RE: character ordering

  • November 1, 2012 at 3:51 am

    #1554917

    For example it's good to know there are accented letters in the area. There are both lowercase and uppercase letters.

    Without tnis knowledge you are not able to understand string comparisons.

    I'm already aware of the existence of accented characters in this collation, without accented characters the collation would not need to be marked as AI or AS.

    When doing string comparisons, I would likewise be aware of accents and case differences on letters and non-standard A-Z alphabetic characters anyway.

    I would also consult a character map for the collation if comparing by ASCII / Unicode decimal or hex values (much easier than messing around with set-based or RBAR CHAR()-based SQL code).

    Your point doesn't detract from mine, which was that this is a pointless question, reliant on the reader's ability to count.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.