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.
| Author |
Topic |
|
bilencekic
Posting Yak Master
121 Posts |
 Posted - 2006-10-28 : 11:52:33
|
| Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Turkish_CI_AS" in the equal to operation. master's collation type is latin and my table collation type is turkishbut it gives error ?HOw to fix it?I can't execute a select statementMS BLESS US |
|
|
bilencekic
Posting Yak Master
121 Posts |
Posted - 2006-10-28 : 12:07:02
|
| i can execute select statement but i cant access through the web pageMS BLESS US |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-28 : 13:40:17
|
nobody can help you unless you post the query. also you should post the ddl for the tables/views the query targets.bonus points for posting some dml to put sample data in the tables.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-28 : 14:17:40
|
Make sure you "cast" the Collation when you compare columns from tables in DIFFERENT databases.ALWAYS specify the collation in your CREATE TABLE statements - and in particular any CREATE TABLE #TEmpTable or DECLARE @TempTableVar TABLE statemenst - and NEVER use SELECT ... INTO #TempTable FROM ... - this avoids having temporary tables use the default collation of the TEMPDB database, which then means you don't have to CAST the collation on anything in Temp Tables  Kristen |
|
|
|
bilencekic
Posting Yak Master
121 Posts |
Posted - 2006-10-28 : 16:11:36
|
| Kristen you are king you are the king of sql =)--after editing proc on temptableproblem is fixed :DMS BLESS US |
|
|
|
|
|
|
Collation problem!!