| From: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
|---|---|
| To: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | pgsql-odbc(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org |
| Subject: | pgAdmin2 UTF-8 support |
| Date: | 2002-02-24 21:39:14 |
| Message-ID: | 200202242139.g1OLdEFP004452@www1.translationforge |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers pgsql-odbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-02-24 22:10:19 | Re: Escaping quotes and double-quotes problem |
| Previous Message | Jean-Michel POURE | 2002-02-24 21:22:49 | Re: Working oin pgAdmin2 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2002-02-25 08:18:14 | Re: [ODBC] pgAdmin2 UTF-8 support |
| Previous Message | Hiroshi Inoue | 2002-02-24 14:00:51 | Re: CRecordSet::GetFieldValue() randomly fails on v7.01.0010 |