Re: FW: Error!

On 5/29/23 09:45, Arquimedes Aguirre wrote:
> Hi, please could update the information about my error with the 
> initialization of psql shell. I am trying to get a connection to develop 
> a web project.
> 
> Thanks for your attention and collaboration.
> 
> Best regards!
> 

> testing:
> - windows installer with default settings, password is quite simple 123456.
> - in pgadmin create a new role with "special" password(i take the german 
> specialties üöä or even some symbols). no errors.
> - in pgadmin add new server with credentials of new role ... automatic 
> try to connect. connected!
> looks like there is nothing wrong at all.
> 
> BUT
> - start the "SQL Shell" or try psql directly.
> - default settings(localhost:5432:postgres:postgres) and the simple 
> password 123456
> - connected. may be a warning about encoding/codepage, but connected.
> 
> try credentials for new role. result: see TO first/last message.
> try change codepage (the docs says 1252 is appropriate for german). same 
> result.
> password file in ANSI, same result.

What is the encoding/locale for the database?

To find out, in psql do

\l <database_name>

and post the result here.

> 
> conclusion: see above
> 

> A.H.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com