Re: Saving Danish Characters to SQL ser 2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 06/03/04 

Date: Thu, 03 Jun 2004 11:09:07 +0200

On Thu, 3 Jun 2004 00:31:02 -0700, ej1007 wrote:

>Still we are having the problem with Case Sensitive. Before our database was Case Insensitive, How I don't know, now it is behaving Case sensitive. Even the table names and Column Names in Query has become Case Sensitive.
>
>If table name is MST_Usr
>Select * from mst_usr will give error saying , mst_usr does not exist.
>
>if we try select * form MST_Usr, it works fine.
>
>How can we make our database Case-Insensitive?
>
>Thanks,
>EJ

Hi EJ,

Choose a different collation. You need to understand the two-letter codes
used in collation names. Check the subject "Windows Collation Name" in
Books Online.

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)