Skip to Content
0

Collate Database Error

Mar 02 at 02:47 AM

17

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers