Board index » delphi » Setting Case Sensitive option for SQL Server 7

Sunil Furtado

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Setting Case Sensitive option for SQL Server 7

Hello Guys,

    Can someone tell me how i can set the case sensitive option in SQL
SERVER 7.0.

    For eg: I was the table field comparision of value a='A' return a false.

    Thanks

Sunil Furtado

 
James Woolfende

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Setting Case Sensitive option for SQL Server 7


Case sensitivity is an option when you do a Custom install of SQLServer
7.
redd

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Setting Case Sensitive option for SQL Server 7


"Sunil Furtado" <su...@furtado.de> wrote

Quote
>     Can someone tell me how i can set the case sensitive option in SQL
> SERVER 7.0.

>     For eg: I was the table field comparision of value a='A' return a

false.

You have to change your server option for "default sort order id". You can
use sp_configure for this.

sp_configure "default sort order id", ??

I don't know what value you need to set this to for case sensitive option.
Look for sort order in BOL.

--Reddy Palle.

Sunil Furtad

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Setting Case Sensitive option for SQL Server 7


Thanks Reddy,

        I will try that.

    Regards,

Sunil Furtado

Quote
reddy <pvre...@rocketmail.com> wrote in message news:397da684$1_1@dnews...

> "Sunil Furtado" <su...@furtado.de> wrote
> >     Can someone tell me how i can set the case sensitive option in SQL
> > SERVER 7.0.

> >     For eg: I was the table field comparision of value a='A' return a
> false.

> You have to change your server option for "default sort order id". You can
> use sp_configure for this.

> sp_configure "default sort order id", ??

> I don't know what value you need to set this to for case sensitive option.
> Look for sort order in BOL.

> --Reddy Palle.

Other Threads

1. SQL Server Case Sensitive Issue

2. SQL Server 6.5 Case Sensitive fields

3. MS SQL-SERVER CASE SENSITIVE

4. SQL Server 6.5 and Case-sensitive

5. Columns Format setting (case sensitive)

6. Case sensitive index - mssql server

7. Case Sensitive vs Case-InSensitive

8. Case sensitive MS SQL6.5 server

9. SQL case sensitive

10. Local SQL case sensitive LIKE operation?!