pgAdmin2 UTF-8 support

Dear friends,

PostgreSQL 7.2 offers extensive UTF-8 support. In case of an UTF-8 database,
the big news seems that we now have to write function and view definitions in
UTF-8.

The problem is that pgAdmin2, HighlightBox (the colour code editor) and the
result view do not support Unicode by now. And probably will not whithout
further information.

Questions :
1) Is it possible to convert functions/views to/from UTF-8/SQL_ASCII using
server-side queries in PostgreSQL. $M cowboys do not offer tools to convert
Unicode on the fly in VB. Is there something in PostgreSQL?

to_ascii can convert from unicode to ascii.
How can we do the converse?

2) Do you know if ODBC UCS-2 support would help us with pgAdmin2? Does anyone
has extensive knowledge of UCS-2 support under VB? As far as I know, VB only
supports reading UCS-2 files and displaying data in Hflexgrid.

Any idea welcome,
Cheers, Jean-Michel POURE