SQL Server Collation Problem

Discussion in 'Databases' started by frankgh, Mar 6, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. frankgh

    frankgh

    Hi, I am using a SQL server 2000 database with discountasp.net. However, we ran into this collation problem. Queries that include a 'WHERE' clause with a string are case insensitive. In other words, this query 'select * from countries where country = 'CANADA' ' will return the same rows as ' select * from countries where country = 'canada' '
    Does anyone know how to solve that problem?

    Thanks
     
    frankgh, Mar 6, 2007
    #1
  2. vvsharma

    vvsharma

    vvsharma, Mar 6, 2007
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page