Thread: Unicode in PGAdmin

Unicode in PGAdmin

From
Tino Wildenhain
Date:
Hi,

what about unicode support in pgadmin? Sure,
one can set client_encoding to iso8859-1 or
so, but then you can't handle different charsets
at the same time. My understanding is there is
a unicode-aware odbc driver already and
VB should also handle unicode like other
windows applications.
Dave, do you think this would have a deep impact
on pgadmin source?

Regards
Tino

Re: Unicode in PGAdmin

From
"Dave Page"
Date:

> -----Original Message-----
> From: Tino Wildenhain [mailto:tino@wildenhain.de]
> Sent: 10 December 2002 20:43
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Unicode in PGAdmin
>
>
> Hi,
>
> what about unicode support in pgadmin? Sure,
> one can set client_encoding to iso8859-1 or
> so, but then you can't handle different charsets
> at the same time. My understanding is there is
> a unicode-aware odbc driver already and
> VB should also handle unicode like other
> windows applications.
> Dave, do you think this would have a deep impact
> on pgadmin source?

Hi Tino,

Contrary to what Microsoft say, VB doesn't support Unicode in any useful
way. Whilst the core language does, none of the UI components (controls)
do. The answer is to use the controls that ship with MS Office, though
as Microsoft point out, that means all users need an Office licence,
which is something I'm not about to require of people.

We are now working on pgAdmin III which is written in C++, and will
eventually support Unicode.

Regards, Dave.

Re: Unicode in PGAdmin

From
Tino Wildenhain
Date:
Hi Dave,

--On Dienstag, 10. Dezember 2002 22:20 +0000 Dave Page
<dpage@vale-housing.co.uk> wrote:

>
>
>> -----Original Message-----
>> From: Tino Wildenhain [mailto:tino@wildenhain.de]
>> Sent: 10 December 2002 20:43
>> To: pgadmin-support@postgresql.org
>> Subject: [pgadmin-support] Unicode in PGAdmin
>>
>>
>> Hi,
>>
>> what about unicode support in pgadmin? Sure,
>> one can set client_encoding to iso8859-1 or
>> so, but then you can't handle different charsets
>> at the same time. My understanding is there is
>> a unicode-aware odbc driver already and
>> VB should also handle unicode like other
>> windows applications.
>> Dave, do you think this would have a deep impact
>> on pgadmin source?
>
> Hi Tino,
>
> Contrary to what Microsoft say, VB doesn't support Unicode in any useful
> way. Whilst the core language does, none of the UI components (controls)
> do. The answer is to use the controls that ship with MS Office, though
> as Microsoft point out, that means all users need an Office licence,
> which is something I'm not about to require of people.
>
> We are now working on pgAdmin III which is written in C++, and will
> eventually support Unicode.

Ah ok. This sounds promising in the aspect of porting to
an "OS" ;)) Will you make it modular in a way porting
is possible? Will it be multithreaded? I've seen there
is native support for postgresql also as win32 libs, so
there should be no need to use ODBC in all circumstances
(For example to catch messages like psql does)

Regards
Tino

Re: Unicode in PGAdmin

From
"Dave Page"
Date:

> -----Original Message-----
> From: Tino Wildenhain [mailto:tino@wildenhain.de]
> Sent: 12 December 2002 16:05
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] Unicode in PGAdmin
>
> Ah ok. This sounds promising in the aspect of porting to
> an "OS" ;)) Will you make it modular in a way porting
> is possible? Will it be multithreaded? I've seen there
> is native support for postgresql also as win32 libs, so
> there should be no need to use ODBC in all circumstances
> (For example to catch messages like psql does)


Hi Tino,

The new version already runs on Windows, Linux and FreeBSD. It should
also run on other Unixes and OS-X, but I don't have any right now. We
also use libpq rather than ODBC now, so yes, we have complete access to
the server.

Regards, Dave.

Re: Unicode in PGAdmin

From
Tino Wildenhain
Date:
Hi Dave,

--On Donnerstag, 12. Dezember 2002 16:02 +0000 Dave Page
<dpage@vale-housing.co.uk> wrote:

>
>
>> -----Original Message-----
>> From: Tino Wildenhain [mailto:tino@wildenhain.de]
>> Sent: 12 December 2002 16:05
>> To: Dave Page; pgadmin-support@postgresql.org
>> Subject: RE: [pgadmin-support] Unicode in PGAdmin
>>
>> Ah ok. This sounds promising in the aspect of porting to
>> an "OS" ;)) Will you make it modular in a way porting
>> is possible? Will it be multithreaded? I've seen there
>> is native support for postgresql also as win32 libs, so
>> there should be no need to use ODBC in all circumstances
>> (For example to catch messages like psql does)
>
>
> Hi Tino,
>
> The new version already runs on Windows, Linux and FreeBSD. It should
> also run on other Unixes and OS-X, but I don't have any right now. We
> also use libpq rather than ODBC now, so yes, we have complete access to
> the server.

Way cool! Is there something in the CVS repository to get envolved?

Regards
Tino

Re: Unicode in PGAdmin

From
"Dave Page"
Date:

> -----Original Message-----
> From: Tino Wildenhain [mailto:tino@wildenhain.de]
> Sent: 12 December 2002 16:12
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] Unicode in PGAdmin
>
>
> Hi Dave,
>
> --On Donnerstag, 12. Dezember 2002 16:02 +0000 Dave Page
> <dpage@vale-housing.co.uk> wrote:
>
> >
> >
> >> -----Original Message-----
> >> From: Tino Wildenhain [mailto:tino@wildenhain.de]
> >> Sent: 12 December 2002 16:05
> >> To: Dave Page; pgadmin-support@postgresql.org
> >> Subject: RE: [pgadmin-support] Unicode in PGAdmin
> >>
> >> Ah ok. This sounds promising in the aspect of porting to
> >> an "OS" ;)) Will you make it modular in a way porting
> >> is possible? Will it be multithreaded? I've seen there
> >> is native support for postgresql also as win32 libs, so
> there should
> >> be no need to use ODBC in all circumstances (For example to catch
> >> messages like psql does)
> >
> >
> > Hi Tino,
> >
> > The new version already runs on Windows, Linux and FreeBSD.
> It should
> > also run on other Unixes and OS-X, but I don't have any
> right now. We
> > also use libpq rather than ODBC now, so yes, we have
> complete access
> > to the server.
>
> Way cool! Is there something in the CVS repository to get envolved?

Yup, check out the pgadmin3 module from cvs.pgadmin.org. There is a web
interface at that address as well.

Regards, Dave.