Post reply

Object_Id 1

  • February 23, 2012 at 12:47 pm

    #1451088

    Thank you for the easy one.

    As far as I know, collation is in part used for handling string literals, isn't it? It shouldn't affect syntax.

    ------------

    A watt of Ottawa.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • February 23, 2012 at 8:00 pm

    #1451159

    I finally understand why I see the N' in some queries and why I got "H e l l o " instead of "Hello" (with space between chars) when the application queried the "nvarchar" columns when I was creating the database. I swiched to varchar instead of taking the time to understand...

    Thanks!

    Is someone knows where to find the list of possible collation and if they are insensitive?

  • February 23, 2012 at 8:35 pm

    #1451164

    I scored one today. Thanks for the easy question.

  • February 24, 2012 at 12:55 am

    #1451208

    Thanks, nice question.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 24, 2012 at 6:43 am

    #1451363

    BarbW (2/23/2012)

    Good syntax question; not sure why collation info was included. Thanks!

    I guess so we knew it was a case insensitive collation

    ---------------------------------------------------------------------

  • February 24, 2012 at 6:49 am

    #1451367

    tilew-948340 (2/23/2012)

    I finally understand why I see the N' in some queries and why I got "H e l l o " instead of "Hello" (with space between chars) when the application queried the "nvarchar" columns when I was creating the database. I swiched to varchar instead of taking the time to understand...

    Thanks!

    Is someone knows where to find the list of possible collation and if they are insensitive?

    Try running this:

    SELECT *

    FROM fn_helpcollations()

    GO

    OR this

    CREATE TABLE #T(Name VARCHAR(50),Description VARCHAR(200))

    INSERT INTo #T

    SELECT * FROM fn_helpcollations()

    SELECT Name, Description FROM #T WHERE Description LIKE '%case-insensitive%'

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 24, 2012 at 7:55 pm

    #1451672

    bitbucket-25253 (2/24/2012)

    tilew-948340 (2/23/2012)

    Is someone knows where to find the list of possible collation and if they are insensitive?

    Try running this:

    SELECT *

    FROM fn_helpcollations()

    GO

    [/code]

    Exactly what I was looking for: 2397 types of collations with their description... impressive!

    I think I already ask that because the query looks familiar to me... but this time, I'll put it in my special book 🙂

    Thanks a lot!

  • February 27, 2012 at 2:06 pm

    #1452297

    Thanks for the good question...

  • March 1, 2012 at 9:53 pm

    #1454011

    Jagadish Kumar Punnapu (2/27/2012)

    Thanks for the good question...

    +1

    Thanks

  • January 11, 2013 at 12:48 am

    #1576091

    L' Eomot Inversé (2/23/2012)

    Nice easy question, nice straightforward answer and explanation.

    I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?

    Good point

    --
    Dineshbabu
    Desire to learn new things..

  • January 5, 2015 at 10:56 pm

    #1767954

    Good to know that, thanx

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 11 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply