Object_Id 1

  • 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]

  • 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?

  • I scored one today. Thanks for the easy question.

  • Thanks, nice question.

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

  • 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

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

  • 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]

  • 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!

  • Thanks for the good question...

  • Jagadish Kumar Punnapu (2/27/2012)


    Thanks for the good question...

    +1

    Thanks

  • 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..

  • Good to know that, thanx

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

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