Viewing 3 posts - 1 through 3 (of 3 total)
I agree with a column type of char(10) as you say. When it is nvarchar(250) on SQL Serveur 2005 if you run the following query :
SELECT LEN(fieldname) FROM table;
May 13, 2008 at 11:42 am
Yes, but this is not the problem.
The exact problem is that for SQL norm if you compare two string with different lengths the first thing done by SQL is to...
May 13, 2008 at 9:36 am
I found the reason why 'a' is equal to 'a ' or 'a '.
ANSI Standard : Have a look to :
May 13, 2008 at 7:48 am