Very Computer

I am trying to make a program, developped with paradox tables, working with
the same table structure on SQL Server.

Here is my problem: Field and table name in SQL sent to paradox are not case
sensitive and they are with SQL server.

Is there a way to configure SQL Server to do not be case sensitive with
fields and tables name when it execute an SQL?

Thank in advance.

Bonjour Fran?ois:

Do you have SQL Server 2000? What is collation identifier
name for your database? To find that execute sp_helpdb
N'YourDatabaseName'. Collation name is in the status
column.

If you have created database without specifying collation,
then your database have default collation
SQL_Latin1_General_CP1_CI_AS, which is Case Insensitive.

Sinisa

Quote:>-----Original Message-----
>I am trying to make a program, developped with paradox

tables, working with

Quote:>the same table structure on SQL Server.

>Here is my problem: Field and table name in SQL sent to

paradox are not case

Quote:>sensitive and they are with SQL server.

>Is there a way to configure SQL Server to do not be case
sensitive with
>fields and tables name when it execute an SQL?

>Thank in advance.

>.

Thanks for your answer

Yes, I have SQL Server 2000

I already tryed to change the collation type to something case insensitive.
The problem is I have some tables with primary key as char(10) and for
exemple with this content : "Left" and "left". If collation type is case
insensitive then I get key violation when I generate this table.

I need to be able to send SQL with case sensitivity at off and manage the
data with case sensitivity at on. Is there a way to do this?

Thanks in advance

Bonjour Fran?ois:

Do you have SQL Server 2000? What is collation identifier
name for your database? To find that execute sp_helpdb
N'YourDatabaseName'. Collation name is in the status
column.

If you have created database without specifying collation,
then your database have default collation
SQL_Latin1_General_CP1_CI_AS, which is Case Insensitive.

Sinisa

For further information on this topic, see "Character Sets And Sort Orders"
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks,

William Chen