Collate Database Error

[former_member280812]

Hi Experts,

We are using our reports in sap b1 for almost 10 years and works fine but now error just came out saying that the collation of the database are conflict. Can anyone help us to fix this error and tell us why this error just came out this days.

We are trying to solve this by adding a line of query inside "COLLATE DATABASE_DEFAULT". See example below query

CREATE TABLE #tblname(

code INT,

branch VARCHAR(50) COLLATE DATABASE_DEFAULT

)

And we adding that line also from the join table like the sample below

SELECT B.* 

FROM INV1 A 

INNER JOIN OITM B ON A.ItemCode COLLATE DATABASE_DEFAULT = B.ItemCode COLLATE DATABASE_DEFAULT

Any help is appreciated, Thank you in advanced.

Regards,

Eric