Confused about default string comparison option on sql
I am completely confused about the default string comparison method used
in SQl. Up till now I had been using UPPER() and LOWER() functions for
performing any string comparison on SQL. However got to know that by
default SQL is case insensitive and we need to change the collation while
installing SQL to make it case sensitive. However if this is the case then
what is the use of UPPER and LOWER() functions.
Can somebody please explain..
No comments:
Post a Comment