Re: [Emerald] case sensitivity problem
Dale E. Reed Jr. ( (no email) )
Mon, 27 Sep 1999 23:09:20 -0700
Ben Conner wrote:
>
> I recently discovered that when I installed SQL Server on my system, I
> chose an option that precluded case checking. Apparently associated with
> the character set chosen, or something along those lines.
>
> Since Emerald assumes lower case isn't the same as upper case, does anyone
> have a suggestion as to how this can be changed? I understand the
> installation itself has to be removed & redone from scratch.
>
> I could export the data to an Access database and reimport it, but wouldn't
> that blow out the primary keys on the tables since they are
> auto-generated? IE, Customer ID 10 coming in would be Customer ID 9 if I
> had deleted customer 9 before.
The only way to do it is transfer the DB to another SQL Server, rebuild
your master DB with the correct sort order, and transfer the DB back.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart