community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Issue with collation between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"

Alteryx Partner

I have a database where i use case sensitive to arrange my data better. @ point 1 my database has a collation "SQL_Latin1_General_CP1_CI_AS". @point 2 Alteryx insert the data in a temp table with the default Collation that is "Latin1_General_CI_AS".

 

 

 Capture error1.PNG

then i get this error when running my flow.

 

 Capture error.PNG

Error: Browse In-DB (11): Error: Microsoft OLE DB Provider for SQL Server: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.\42000 = 468
in Query: .....

 

Where / how can i tell Alteryx to ignore this error of tell it to use a different Collation...

 

regards

 

Humberto Kelkboom

 

 

Moderator
Moderator

@Kelkboom - would you be able to set the collation using the Pre-SQL statement in the Input tool configuration?

Sophia Fraticelli
Customer Support Engineer
Highlighted
Atom

I am trying to work through this error:

Error: Browse In-DB (25): Error: Microsoft OLE DB Provider for SQL Server: Cannot resolve the collation conflict between "SQL_Latin1_General_CP850_BIN2" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.\42000 = 468

 in Query:

 

I believe I need to use a COLLATE clause.  Can I use it in the query builder configuration screen of the In-Database Connect IN-DB?

Can you provide an example?

 

Thanks!

Alteryx Partner
I made sure that all my DB's have the same Collation properties. Regards Humberto
Labels