tag:blogger.com,1999:blog-6894552.post954364099098282285..comments2011-09-03T20:17:23.298-07:00Comments on JMPInline: The case for case sensitive OpenID URL checkingAndrew Arnotthttps://profiles.google.com/114635397638720587251noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6894552.post-19803559918757659882011-09-03T19:26:05.295-07:002011-09-03T19:26:05.295-07:00Andrew, which databases did you have in mind? (Tha...Andrew, which databases did you have in mind? (That perform case insensitive string comparisons by default)Kaj Magnushttp://www.blogger.com/profile/18054221902017877054noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-48904573523178124442009-12-11T14:45:29.775-08:002009-12-11T14:45:29.775-08:00This took me a while to figure out: to make SQL se...This took me a while to figure out: to make SQL server consider your OpenID claimed identifier lookups to be case sensitive, you should make sure that column's collation is set to be case sensitive:<br />COLLATE SQL_Latin1_General_CP1_CS_ASAndrewhttp://www.blogger.com/profile/13632400519774640095noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-31013683140231897932009-03-26T06:53:00.000-08:002009-03-26T06:53:00.000-08:00SPO256,<br><br>I think you're missing several crit...SPO256,<BR/><BR/>I think you're missing several critical pieces to why this article relates to everyone:<BR/><BR/>Microsoft operating systems are only <I>usually</I> case insensitive, although they can be case sensitive. Linux servers can absolutely be case insensitive. It's a switch in Apache's configuration file.<BR/><BR/>But file systems have nothing to do with case sensitivity as it relatesAndrewhttp://www.blogger.com/profile/13632400519774640095noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-32830489202789851872009-03-25T23:24:00.000-08:002009-03-25T23:24:00.000-08:00Any programmer or tech worth their salt knows that...Any programmer or tech worth their salt knows that "case insensitive" comparisons are actually more laborious to perform. Also, the only time URLs are not case sensitive (apart from the domain name) is on MS servers (as the file system is not case sensitive for some poorly construed reason dating back to MS DOS).<BR/><BR/>Despite this obvious fact, you point out that we should take care. SPO256http://www.blogger.com/profile/08173273548919352340noreply@blogger.com