Special Character is Datasource
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Database Connection
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Postgres
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
And what driver? ANSI 32-bit driver or the Unicode® ODBC driver?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MichalM ANSI 32 bit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
pulling the data through the unicode driver instead of ANSI worked. thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome. Glad to hear.