Thread: psql umlaute E4 E6

psql umlaute E4 E6

From
"Harald Massa"
Date:
Hello,

I successfully installed

    postgresql 7.2 using cygwin on win2k, using a recent snapshot of cygwin
(2002021x)

psql works.

I also was able to import a database dump generated on a linux machine under
postgres 7.1.3.

BUT umlaute (ä, ö, ü (ae, oe, ue)) are shown as <E4> and <E6> ... on psql.
(but correctly in sort order).

pgAdminII shows the correct letters.

I run psql in the bash shell of cygwin.

What can I do to see the correct letters also in psql?

Harald


Re: psql umlaute E4 E6

From
Jason Tishler
Date:
Harald,

On Thu, Feb 14, 2002 at 06:09:46PM +0100, Harald Massa wrote:
> BUT umlaute (ä, ö, ü (ae, oe, ue)) are shown as <E4> and <E6> ... on psql.
> (but correctly in sort order).
>
> pgAdminII shows the correct letters.

I think that this is because pgAdminII is a straight Win32 app and not
a Cygwin one.

> I run psql in the bash shell of cygwin.
>
> What can I do to see the correct letters also in psql?

[Being from the US, I locale challenged... :,)]

IIRC, Cygwin does not have full locale support.  However, I seem to
remember some Cygwin mailing list post regarding locale.  So, I recommend
searching the archives:

    http://cygwin.com/ml/cygwin/

to see if you can find a solution.  If you so, please report back to
this list.

Thanks,
Jason

Re: psql umlaute E4 E6

From
"Harald Massa"
Date:
Jason,

> IIRC, Cygwin does not have full locale support.  However, I seem to
> remember some Cygwin mailing list post regarding locale.  So, I recommend
> searching the archives:
>
>     http://cygwin.com/ml/cygwin/
>
> to see if you can find a solution.

I did scan. And learned. Cygwins locale support is total. Total as in "total
broken". Many many complaints about the locale support in the dll, a
"--showcontrolchars" patched into ls.

and ONE idea ... to compile mutt using the

    --enable-locales-fix

switch for gcc. So I have to set up a compiling environment or ask someone
to try this switch who allready has a compiling environment.

Thank you very much for the lookup-path

Harald


> this list.
>
> Thanks,
> Jason
>