Encoding and Postgres

Question

I am writing a .csv file to postgres. When I view the data in the browse tool it looks fin, but when I write the data to postgres the data has an encoding issue.

I append the data to an existing table in the database. The data in the table has correct encoding.

Any help?

Thank you.

TrineLouringNielsen · Answer

Hi Dan

The encoding of my database is UTF8.

Sorry, I need a bit more help since I am new in Alteryx.

I am not sure how to use the ConvertToCodePage(s, codePage)  function. And I did not manage to find a lot of information on the issue.

I guess, I have to use the formular tool and put in the function ConvertToCodePage(s, codePage)  where the codepage is ISO-8859-1 (I think).

What about the 's'?

Thanks in advance.

Trine

danilang · Answer

Hi @TrineLouringNielsen

Once you find out the encoding used in your db, you can use the Alteryx function ConvertToCodePage(s, codePage) to convert your strings to the corresponding code page

Dan