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: Sunday, January 4, 2015 7:55 AM
Points: 5,333, Visits: 25,280
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: Saturday, January 31, 2015 6:21 AM
Points: 127, Visits: 107
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: Thursday, November 20, 2014 5:13 AM
Points: 1,131, Visits: 1,394
Jagadish Kumar Punnapu (2/27/2012)
Thanks for the good question...

+1


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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 5, 2015 4:29 AM
Points: 1,028, Visits: 569
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
Posted Monday, January 5, 2015 10:56 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:44 AM
Points: 2,028, Visits: 888
Good to know that, thanx
Post #1648510
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse