I have couple of basic questions regarding Sybase.
If I have a column in Sybase of Varchar length of 10 characters and I insert more than 10 character then Sybase ASE automatically chops off (truncates) the character beyond 10. But MS SQL server does produce an error. I want Sybase to produce an error. Can you please let me know is there any global level setting I need to do in Sybase ASE. I am using 12.5.3 version of Sybase.
My another question is that Sybase is case sensitive when it comes to data search like suppose I want to search all the names with letter 'ABC' from employee table then I can write query like this
SELECT name from emp where name = 'abc' in SQL Server it will return me row with name "ABC" irrespective of passing lower case. But Sybase does not return value unless we specify "ABC" in where clause.
Since I am migrating to Sybase so I want Sybase to behave in same way. Is there any global level server setting I can do in Sybase. Like i said I am using Sybase ASE 12.5.3
Like always your help is very much appreciated..
Thank a lot.