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?

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