Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to config sybase to let data case-insensitive

2 posts in Windows NT Last posting was on 2000-04-14 12:47:36.0Z
David Yao Posted on 2000-03-29 17:04:38.0Z
Reply-To: "David Yao" <david.yao@cwusa.com>
From: "David Yao" <david.yao@cwusa.com>
Subject: How to config sybase to let data case-insensitive
Date: Wed, 29 Mar 2000 11:04:38 -0600
Lines: 10
Organization: CW
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <ex$8qGam$GA.298@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: hoya.cwusa.com 146.135.27.10
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2372
Article PK: 1089811

I have sybase ASE11 running on Linux. The problem is all data are
case-sensitive. For example, 'DEMO', 'deMo' are different.

Which change should be made to let all data case-insensitive?

Thanks,
David


Andre Felipe Barrocas Moreira Posted on 2000-04-14 12:47:36.0Z
Message-ID: <38F71368.31C7FEC7@ihcap.com.br>
Date: Fri, 14 Apr 2000 09:47:36 -0300
From: Andre Felipe Barrocas Moreira <support@ihcap.com.br>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: Re: How to config sybase to let data case-insensitive
References: <ex$8qGam$GA.298@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 11
NNTP-Posting-Host: cs0112.esquadro.com.br 200.214.4.62
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2319
Article PK: 1089748

Change the sort order to 44 - noaccents - Case insensitive dictionary.
Marcelo Teixeira Affonso
Icatu Hartford Capitalizacao -Rio de Janeiro - Brazil

David Yao wrote:

> I have sybase ASE11 running on Linux. The problem is all data are
> case-sensitive. For example, 'DEMO', 'deMo' are different.
>
> Which change should be made to let all data case-insensitive?
>
> Thanks,
> David