Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Special Character is Datasource

jrietdijk
5 - Atom

I am trying to pull a table from our data warehouse but keep getting the following error.

 

Error: Input Data (1): Error SQLExecute: ERROR: character with byte sequence 0xc5 0x83 in encoding "UTF8" has no equivalent in encoding "WIN1252";Error while executing the query

 

I have narrowed down the cause of this error to be a specific row and field in the dataset, a city name field "POZNAŃ".  My guess is the accent on the N is causing alteryx to crash.

 

There are no issues in the data warehouse itself, but i can't load the table to Alteryx without omitting the field.  Anyone have any experience with this?

 

Thanks, J

6 REPLIES 6
MichalM
Alteryx Alumni (Retired)

@jrietdijk 

 

What is the database you're using?

jrietdijk
5 - Atom

@MichalM 

Postgres

MichalM
Alteryx Alumni (Retired)

And what driver? ANSI 32-bit driver or the Unicode® ODBC driver?

jrietdijk
5 - Atom

@MichalM ANSI 32 bit

jrietdijk
5 - Atom

pulling the data through the unicode driver instead of ANSI worked.  thanks!

MichalM
Alteryx Alumni (Retired)

Awesome. Glad to hear.

Labels
Top Solution Authors