Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


How to disable case sensititive?

Posted on 2003-02-19
Medium Priority
Last Modified: 2008-03-17

Can someone pls tell me how to disable case sensitive in ASE.

Question by:CYRI
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 7994706
Case sensitivity is set on the server when the sort order is selected

Author Comment

ID: 7997790

What is the sort order that needsto  be selected?

Accepted Solution

vka3 earned 120 total points
ID: 7998843
Depending upon the language charset you have selected, you can set the sort order. See table 7-5 on page 272 of Sybase Admin Guide Vol 1 (ASE 12.5).
It supports "Dictionary order, case insensitive, accent sensitive" for English.

You can use following to set.
sp_configure "default sortorder id",sortorderid

sp_helpsort to see the current sortid.

Try 'nocase' or 'nocasep' which is available for UTF-8.

Check all sort order ids from
"select name,csid,id from syscharsets" to choose the right sort order for case insensitivity.

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
What we learned in Webroot's webinar on multi-vector protection.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question