Issue with collation between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"

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

Datasets

In Database

Database Connection

In-Database

Accepted answers

SophiaF

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

All comments

SophiaF

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

rlease

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!

akasubi

Hi @SophiaF, I know this is an old thread but I'm experiencing the same issue. I've set the collation in the pre-sql statement as I've had to do that to join to some tables.

My issue seems to be when I try to join with an excel file that I've data streamed into my SQL environment. Is there a way I can set a collation on the excel data coming in?

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703