Case sensitivity for table and column names for MS SQL Server 6.5

Case sensitivity for table and column names for MS SQL Server 6.5

Post by Erland Sommarsk » Sun, 07 Sep 1997 04:00:00




Quote:>We are extending our application to work SQLBase and MS SQL Server 6.5.
>We installed MS SQL Server using dictionary case-sensitive sort order and
>have problem:
>All our queries were written used some styles: ones wrote CUSTOMERS,
>otheres - Customers and customers.
>SQLBase translated all to CUSTOMERS, but SQL Server can't find obects
>(tables and columns) and raise error.
>We can not set dictionary case-insensitive sort order, because data are
>case-sensitive.

>Does exist any solution?

Not within SQL Server, however, if your table and column names are
distinct enough, you should be able to fix your code by running
it through some general search/replace tool. If you know Perl, this
is a perfect tool for the task.

You may also want to reconsider your position on using a case-sensitive
sort order. You say that your data is case-sensitive, but I'm a little
uncertain what you mean by that. Would really "Jeltsin" and "JELTSIN"
be two different customer names? Or do you mean that you want to
preserve the case that the user entered? In such case, case-insensitive
is the way to go, because SQL Server will change no case, and the user
is much happier if he does not have to remember if he put in "Jeltsin"
or "JELTSIN" when he initially added the customer to the data base.

--

F=F6r =F6vrigt anser jag att QP b=F6r f=F6rst=F6ras.
B=65sid=65s, I think QP should b=65 d=65stroy=65d.

 
 
 

1. How can I remove Sybase case sensitivity on table and column names

Hi,

I want to change an Oracle ODBC source to a Sybase one.

The problem is that Oracle is not case sensitive and accept SQL Statements
with
table and column names in lowercase or uppercase.

Is there a way to make Sybase work like Oracle or will I be rewriting
something like 1000 statements in uppercase?

Thanks,

Thierry MARTY.

2. OODBMS Request for info

3. Case-sensitivity in SQL Server 6.5

4. Primary key guaranteed unique?

5. Case sensitivity in SQL Server 6.5

6. Best way to compare contents of two tables?

7. Bug#108286: case sensitivity in column names

8. D2 Newbie Q: Filtering a Database

9. MS SQL Server 6.0 case sensitivity question

10. Case Sensitivity and MS Sql Server

11. Case sensitivity in SQL 6.5

12. Question on Scope of Case-Sensitivity on a Case-Sensitive SQL Server 7.0/2000

13. table name case sensitivity