Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SELECT Query Turkish Char Problem??

Author  Topic 

raysefo
Constraint Violating Yak Guru

260 Posts

Posted - 2011-08-17 : 03:32:03
Hi,
I am trying to query a table as follows.The problem is, eventhough there are records in the table, NO result returns. How can I fix this?

Best Regards.

select City,cmonth,cyear from Table1 Where (City in ('AGRI') ) group by city,cmonth,cyear order by city,cmonth,cyear

raysefo
Constraint Violating Yak Guru

260 Posts

Posted - 2011-08-17 : 03:38:05
#286; Capital G-breve
Go to Top of Page

raysefo
Constraint Violating Yak Guru

260 Posts

Posted - 2011-08-17 : 03:59:30
City COLLATE Turkish_CI_AS solved the problem
Go to Top of Page
   

- Advertisement -