Last post Jan 04, 2016 10:54 PM by ninianne98
Jan 03, 2016 05:18 PM|pn_nq|LINK
my sql server can't recognize the capital letter. anyone know how to set it.
for example when i write the script with 'GO' word, it can't compile the script. but i change the word from BLOCK letter to capital letter 'go' . it work properly.
how to set it so that it can recognize both letters?
Jan 04, 2016 12:41 AM|oned_gk|LINK
string str = "GO";
if (str.ToLower() == "go")
Jan 04, 2016 05:58 AM|Nan Yu|LINK
Try to use LOWER function which will return a character expression after converting uppercase character data to lowercase:
LOWER ( character_expression )
Please refer to below article for more details :
Jan 04, 2016 12:11 PM|PatriceSc|LINK
It happens for table name as well? Could it be that you created a case sensitive db? (though I wonder if go which is afaik just a client side marker to separate batches should be affected).
Try something such as SELECT name,collation_name FROM sys.databases to see which collation is used for your db.
Jan 04, 2016 01:02 PM|pn_nq|LINK
Jan 04, 2016 10:54 PM|ninianne98|LINK
maybe a misconfigured collation setting?
http://stackoverflow.com/questions/14962419/is-the-like-operator-case-sensitive-with-ms-sql-server , and