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