Passwords containing certain symbols do not function correct

I am attempting to connect natively to AWS Aurora PostgreSQL. When I register the connection information in SQL Assistant and test it, I receive the error “password authentication failed for user ‘xxxx’”.
I have confirmed this with multiple users; if the password contains a semicolon (;), an error occurs. There may be other symbols that also cause password errors.
I have specified the following options for the connection, but the option settings do not seem to be related.
Encrypt Connection = Yes
SSL Mode = require

Translated with DeepL.com (free version)

Semicolon is used is a separator in the Postgres connection string constructed by SQL Assistant when using Native connection driver method. Using that symbol in passwords and other parts will make the connection string parsed incorrectly with the default settings, which is why you get Invalid password error.

The suggested workaround for cases when password can't be changed to something else without a semicolon is switching to ODBC connection. With ODBC connection you would create a data source in ODBC Administrator, be sure that user and password are saved in the created ODBC profile. SQL Assistant SQL Editor, in the connection dialog, choose ODBC for the Connection Type, and then choose the data source name in the dropdown for DSN/Driver, look for the line starting with DSN=your ODBC profile)