Very Computer

by **USF S** » Thu, 06 Oct 1994 04:01:02

I know that switching between a case sensitive and case insensitve server
using Sybase is a major issue, actually I belive I was told it is
impossible. However I am at a NT MS SQL Server based client who now feels
that his case sensitive server is causing his people headaches and would
like to switch to case insensitive. If anyone has actually performed the
switch on NT or knows if it is impossible your help would be very much
appreciated.

TIA
Tom
Platinum Software Corp

by **Greg Fie** » Fri, 07 Oct 1994 01:05:53

: I know that switching between a case sensitive and case insensitve server
: using Sybase is a major issue, actually I belive I was told it is
: impossible. However I am at a NT MS SQL Server based client who now feels
: that his case sensitive server is causing his people headaches and would
: like to switch to case insensitive. If anyone has actually performed the
: switch on NT or knows if it is impossible your help would be very much
: appreciated.

To change the sort order you *must* re-install NT MS SQL Server. All
of the system tables, etc are built based on the defined sort order.

Be very careful when changing the default sort order. Once we re-installed
to change the sort order and 'OK'd when we should have 'Done'd or something
and the server came up in the default sort order--Very frustrating :(.

Sort order is a big decision, since servers with different sort orders cannot
share backups and will have problems sharing data ('Smith' and 'SMITH'
are distinct values for case-sensitive, and the same for case-insensitive).

Good luck,

Greg

(in search of a cool signature file...)

by **george anders** » Sun, 09 Oct 1994 02:04:17

>Path: commpost!uupsi!psinntp!news.intercon.com!zilker.net!gfield

>Newsgroups: comp.databases.sybase
>Subject: Re: Case Sensitivity and MS Sql Server
>Date: 5 Oct 1994 16:05:53 GMT
>Organization: Zilker Internet Park, Inc.
>Lines: 25

>NNTP-Posting-Host: oak.zilker.net
>X-Newsreader: TIN [version 1.2 PL2]

*** YOU DO NOT HAVE TO REINSTALL SQL SERVER TO CHANGE SORT ORDER... SQL Server
will rebuild indexes on the system tables after the sort order has been
changed. The best thing to do is to open a tech support case and have them
walk you through the change...

>: I know that switching between a case sensitive and case insensitve server
>: using Sybase is a major issue, actually I belive I was told it is
>: impossible. However I am at a NT MS SQL Server based client who now feels
>: that his case sensitive server is causing his people headaches and would
>: like to switch to case insensitive. If anyone has actually performed the
>: switch on NT or knows if it is impossible your help would be very much
>: appreciated.
>To change the sort order you *must* re-install NT MS SQL Server. All
>of the system tables, etc are built based on the defined sort order.
>Be very careful when changing the default sort order. Once we re-installed
>to change the sort order and 'OK'd when we should have 'Done'd or something
>and the server came up in the default sort order--Very frustrating :(.
>Sort order is a big decision, since servers with different sort orders cannot
>share backups and will have problems sharing data ('Smith' and 'SMITH'
>are distinct values for case-sensitive, and the same for case-insensitive).
>Good luck,
>Greg
>(in search of a cool signature file...)

by **Brian Mora** » Sun, 09 Oct 1994 00:51:46

The same issues that apply with a Sybase server, also apply with
SQL NT. You cannot change the sort order of a server without
rebuilding master. Period.

However the SQL Transfer Manager will transfer data between
servers of a different sort order. When possible I use this
approach, otherwise you're looking at BCP with the /c option...

Brian Moran
DataFocus Inc

by **Michael Buini** » Sat, 15 Oct 1994 13:53:58

An additional consideration is that setting up a server as case-insensitive
can reduce performance by about 25% (according to manuals).

Michael Buining