Special Character is Datasource

[jrietdijk]

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

[MichalM]

@jrietdijk 

What is the database you're using?

[jrietdijk]

@MichalM 

Postgres

[MichalM · Accepted solution]

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

[jrietdijk]

@MichalM ANSI 32 bit

[jrietdijk]

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

[MichalM]

Awesome. Glad to hear.