I have an ETL process collecting data from a PostgreSQL database and xls files and inserting in a PostgreSQL database that process occurs great in a local DB in Postgres 14 with UTF8 codification and Spanish_Cuba.1252 collation but when I execute that process in dev which is in a docker container with Postgres 15.4 and UTF8 encoding with collation en_US.utf8 the words with accents and "ñ" looks like an interrogation symbol(see the picturebad accents), what can I do to fix this?
To solve this I've tried to mock the environment that dev's has in my local machine, so I installed a Postgres 15 with the same encoding and collation and the process occurs fine as well, so now I'm thinking that the problem is in my ETL tool, which I've been using for more than 10 years and always worked great, now I'm using the 9.4 version of that tool (Pentaho Data Integration) also known as kettle, there I’ve tried using parameters in the connection to specify the encoding needed, I’ve checked the xls files encoding as well
we have found the solution to our accents problem, a colleague of mine got the idea to use xlsx instead of xls and the magic happened, thanks to all for your support