June 6, 2006 at 9:38 am
Hello,
I am not that much confident with SQL Server...but need to give service to few of Japanese clients. For searching the Japanese char records , we are using Japanese_BIN collation. But when Japanese_BIN collation is used, we are not able to execute Stored Procedures (We get an exception 'Invalid object name '). When we change collation to Japanese_CI_AS, the same stored procedure works perfectly well. Is there any relation bewteen collation and Stored Procs??
Please help me if anyone knows anything regarding this issue.
Regards,
Ashu
June 6, 2006 at 1:29 pm
Japanese_BIN means Japanese Binary sort order which tells SQL Server it must be case sensitive because case sensitivity is required for SQL Server Binary sort order. So SQL Server is not understanding your case insensitive stored procs because it is expecting case sensitive stored procs. Sort is related to comparison and equality evaluation so Binary Sort is the fastest but also the most restrictive in SQL Server. Hope this helps.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply