ASP.NET Discussion - collation conflict in sql data adapter

Print Page | Close Window

collation conflict in sql data adapter

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5409
Printed Date: 29 March 2026 at 10:53am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: collation conflict in sql data adapter

Posted By: nima555ir
Subject: collation conflict in sql data adapter
Date Posted: 31 August 2003 at 11:36pm

hi
i have a sql server database which its collation is set to Arabic_CS_AL.
i want to use a sql data adapter to retrieve data from one of its table.

my table name is test
and its have there column :
1. idno(primary key and auto increment)
2. name(nvarchar)
3. family(nvarchar)

but but when data adapter want to generate INSERT , UPDATE and DELETE statement ,i recieve this error :
ADO error: Cannot resolve collation conflict for column 2 in SELECT statement.
plz help me how can i correct this error.
thanx

Replies:

Posted By: Diep-Vriezer
Date Posted: 03 September 2003 at 2:33pm

I'm sorry, I really don't know this. But, why use arabic and not UTF-8 (or am I completely missing the point...).

-------------
Gone..