Re: Oracle versus MS Sql Server

On 18 Oct 2001, Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> spake and said:

> We use some SQL Server boxes here and my colleague, the MSS
> guy, rants almost daily about the one major fly in the
> ointment with MSS.
>
> It appears, and I have only his word for it, that MSS when
> installed on a server, requests a 'sorting sequence' either
> binary or some other choice. From that point onwards, EVERY
> database created on that server has to have the same sort
> order.
>
> This makes life a bit difficult when he gets customer
> exports to import, and he has to find out the sort order
> before he can choose which server to install it on.

That was a limitation with M$ SQL Server 7.0 and earlier. SQL Server 2000 allows multiple collating sequences. Received on Thu Oct 18 2001 - 22:21:55 CDT