Lists: | pgsql-odbc |
---|
From: | "Marcus Better" <marcus(at)dactylis(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Unicode, ODBC and MS Access |
Date: | 2003-02-20 09:40:38 |
Message-ID: | 000701c2d8c4$283d70a0$e79e65d5@KELEV |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Hello,
I have some problems which I think have to do with Unicode strings in
Windows.
Currently, my database is set to Unicode encoding (which I understand means
UTF-8). I use Windows-based programs (running on .NET) through ODBC to
insert some text in UCS-2 encoding.
Now when I try to read that data using the same client program, it
sometimes truncates long strings (after a few hundred characters or so).
Moreover, if I access the same tables using Access XP, in most cases the
text is garbled. I see only fragments of the text, with garbage characters
in it, or in some cases no text at all.
What is the correct way to set up a database (with appropriate encoding)
and ODBC drivers so that Windows programs can read and write Unicode text
(UCS-2)?
Thanks,
Marcus B.
From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Marcus Better <marcus(at)dactylis(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Unicode, ODBC and MS Access |
Date: | 2003-02-20 10:07:21 |
Message-ID: | 3E54A8D9.E4EDDCEC@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Marcus Better wrote:
>
> Hello,
>
> I have some problems which I think have to do with Unicode strings in
> Windows.
>
> Currently, my database is set to Unicode encoding (which I understand means
> UTF-8). I use Windows-based programs (running on .NET) through ODBC to
> insert some text in UCS-2 encoding.
>
> Now when I try to read that data using the same client program, it
> sometimes truncates long strings (after a few hundred characters or so).
>
> Moreover, if I access the same tables using Access XP, in most cases the
> text is garbled. I see only fragments of the text, with garbage characters
> in it, or in some cases no text at all.
>
> What is the correct way to set up a database (with appropriate encoding)
> and ODBC drivers so that Windows programs can read and write Unicode text
> (UCS-2)?
Which driver are you using ?
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
From: | "Marcus Better" <marcus(at)dactylis(dot)com> |
---|---|
To: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Unicode, ODBC and MS Access |
Date: | 2003-02-20 14:19:11 |
Message-ID: | 001d01c2d8eb$136fbf80$509e65d5@KELEV |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
> Which driver are you using ?
PostgreSQL+ Unicode (Beta) version 7.02.0003.
From: | "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "'Marcus Better'" <marcus(at)dactylis(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Unicode, ODBC and MS Access |
Date: | 2003-02-20 14:25:26 |
Message-ID: | 001601c2d8eb$ea0f7170$0e283ddb@PbgX |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Marcus Better [mailto:marcus(at)dactylis(dot)com]
>
> > Which driver are you using ?
>
> PostgreSQL+ Unicode (Beta) version 7.02.0003.
Please try the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/ .
Maybe a little better.
regards,
Hiroshi Inoue
From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org> |
Cc: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Newer ODBC drivers : exellent ! |
Date: | 2003-02-24 03:51:55 |
Message-ID: | 3E5996DB.7075EBD1@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Emmanuel Charpentier wrote:
>
> This is mostly a success note, to let all potential ODBC users
> know that the "snapshot" ODBC drivers as proposed by Hiroshi are
> a great help ... for use with Windows applications. Those drivers
> have cured me of at least two big headaches.
>
> Therefore a question : Hiroshi : do you plan to port them back
> to the Unix source tree ? They would be *really* useful, if only
> for Openoffice and/or R users (I'm both ...). I tried to port the
> enhancements you propose in the unix source tree (as (magnificiently)
> maintained by Oliver Elphick) ... and botched up royally !
I seem to have committed most changes in the snapshot to
the current cvs.
> Another one : the "example" jpeg about miltibyte character support
> on the snapshot page exhibits a checked "(Exp) Updatable cursors"
> checkbox. However, the SQL commands doc for DECLARE tells me that
> PostgreSQL cursors are still read-only. Which is right ?
The Updatable cursor functionality is implemented in the
driver not at the backend side.
> A couple of suggestions, too : updating the driver's docs about
> novelties in 7.3 (schema, among others) would be a Good Thing (TM).
> Reintegrating this doc (even in a terse format) in the "Client
> interfaces" part of the PostgreSQL doc tree would be a Yet Better
> Thing (R). And referring the "snapshot drivers" page somewhere on
> the Gborg site would be a great idea, too ...
Unfortunately I'm not a native English speaker. I hope
someone would update it.
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/