Home Forums Article Discussions Article Discussions by Author Discuss content posted by bitbucket Object_Id 1 RE: Object_Id 1

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