Special character in database password

[zsword]

I want to connect a postgresql database to a job talend but database password contain special character ù and talend send me this error
Caused by: java.lang.IllegalArgumentException: value contains character 'ù' which is non US-ASCII
I search on forum but i never find solution to this problem.

Thank you for your help.

[mpc]

Hi, 

Did you try to use escape char insted of ù, as described here; https://www.postgresql.org/docs/current/libpq-connect.html#AEN39024

Moreover, as far as I know, it's not recommanded to use special char in PostgreSQL DB password, except the list here: https://kb.iu.edu/d/aphg 

Personally I prefer use passphrase to avoid this kind of problems. 

Last option then should be to ask for a password change. 

Kind regards