Alteryx Designer

Definitive answers from Designer experts.

Break Fix - UTF-8 encoding error when connecting to PostgreSQL


Environment Details

All versions of Designer/Server

PostgreSQL 9.4


This error (or similar) indicates that you have a character that can't be encoded properly:

Error: Input Data (1) Error SQLExecute: ERROR: character with byte sequence 0xef 0xbc 0x8c in encoding "UTF8" has no equivalent in encoding "WIN1252"

Using a character that has no ASCII translation can throw an error when connecting to PostgreSQL with the PostgreSQL ANSI driver. The character has a UTF-8 or UTF-4 translation but can't be handled by the PostgreSQL ANSI driver.


PostgreSQL has multiple choices for drivers: ANSI and UNICODE. Connect to PostgreSQL with UNICODE driver and it should resolve the UTF-8 encoding error.