Message-ID: <38042599.75433A1C@ppc.pims.org>
Date: Wed, 13 Oct 1999 08:24:25 +0200
From: "Allan Huffman" <huffmana@ppc.pims.org>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC ODBC text problem
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

 resent message with JDBC ODBC in the subject

Dear Fellow Developers and Hackers,

After installing PostgreSQL 6.5.2 (on my Sparc 7) and configured as
follows:
“--with-mb=UNICODE”

I am getting a truncation of some varchar columns.  When accessing a
PostgreSQL  table1.  I get this error in my postmaster window:

“ERROR: Conversion between UNICODE and SQL_ASCII is not supported”

And this error in my DOS window (which Visual Café Database Edition ises
to run applets from):

“The maximum width size for column 2 is: 17”

table1:
+---------------------------------------+
!     Field       !     Type         !  Length   !
+--------------------------------------+
! data_code   !     varchar()   !    15       !
! data_field    !     varchar()   !    43       !
+--------------------------------------+

From my PC Java GUI, running in Visual Café, I am able to enter a full
15 character string into data_code but I get the following error when I
try to enter a 43 (or greater than 17) character string into data_field:

“Invalid value for the column data”

and it truncates the data I enter to 17 characters.

From a psql prompt on the same Sun that is running the postmaster I can
change the table without the truncation and no mention of UNICODE!  (
For example:

+__________________________________________________________________________+

Without UNICODE configured I got the following errors:

From the Postmaster:

"ERROR: MultiByte strings (MB) must be enabled to use this function. "

From Visual Café:

"The maximum width size for column 2 is: 17"

+__________________________________________________________________________+

Any suggestion will be greatly appreciated, even a work around.

Sincerely,

Allan