Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Object_Id 1 Expand / Collapse
Author
Message
Posted Friday, February 24, 2012 6:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:50 PM
Points: 5,322, Visits: 25,235
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

Before posting a performance problem please read
Post #1257380
Posted Friday, February 24, 2012 7:55 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:37 PM
Points: 589, Visits: 2,437
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!
Post #1257741
Posted Monday, February 27, 2012 2:06 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 17, 2014 9:44 AM
Points: 127, Visits: 105
Thanks for the good question...
Post #1258524
Posted Thursday, March 1, 2012 9:53 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 7, 2014 10:22 PM
Points: 1,126, Visits: 1,387
Jagadish Kumar Punnapu (2/27/2012)
Thanks for the good question...

+1


Thanks
Post #1260603
Posted Friday, January 11, 2013 12:48 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 4, 2014 5:38 AM
Points: 945, Visits: 558
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..
Post #1405789
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse