Encoding and Postgres

[TrineLouringNielsen]

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.

[danilang]

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

[TrineLouringNielsen]

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