troubleshooting Question

Sybase truncates charcaters in the column and data is case sensitive unlike SQL Server

Avatar of Prakash_Mishra
Prakash_Mishra asked on
Sybase Database
5 Comments1 Solution1150 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros