Are these the actual definition of the tables? I may be that the
database designer put a collation on one of the product name columns.
Perhaps to force a sort or something else. Try this, in enterprise
manager select both tables, then right click, select all tasks, then
generate SQL. Look at the results, if there are different collations you
should see them there. I don't know of any other way to see this
information but it is in the system tables.
> -----Original Message-----
> From: Carmen Sanz [mailto:c.sanz@g...]
> Sent: Thursday, March 28, 2002 11:26 AM
> To: sql language
> Subject: [sql_language] collation conflict for equal to operation
> well, I cannot believe I am having problems with this kind of queries
> but I guess I am missing something important.
> I have got two tables :
> Create table fc
> (week_no int,
> product_name varchar(100),
> amount int)
> Create products
> (id numeric,
> product_name varchar(256)
> I just need to join them ... and I do it as follows:
> select *
> from fc, products
> where fc.product_name = products.product_name
> Can somebody tell me, why I get the following error?
> "Server: Msg 446, Level 16, State 9, Line 1
> Cannot resolve collation conflict for equal to operation."
> Thanks a lot!
> to unsubscribe send a blank email to leave-sql_language-