Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Encoding Settings on Dynamic Input or issue with ODBC?

TheTerrabull
5 - Atom

Hey all

 

I am trying to send a query to Snowflake via ODBC using the Dynamic Input Tool.

A string being dynamically added to the query includes the character: ë,

However this character is not making it through to Snowflake 

 

When I run the query directly within Snowflake it runs fine.

From what I can find, this seems to be an encoding issue, however I can't find any settings in the Dynamic Input Tool to address this.

 

Any thoughts on how to address?

 

Kind regards

2 REPLIES 2
psyrio
9 - Comet

Hello,

 

I have the same problem.

 

Regards,
Bruno

jdminton
12 - Quasar

Additional information is likely needed to help here, but it sounds like the code page settings need to be changed in the dynamic input tool config. If it is set to Latin 1, some special characters and symbols may not be recognized.

jdminton_0-1685626889438.png

 

Labels