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 uses
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 (select) the table without the truncation and no mention of
UNICODE!

+__________________________________________________________________________+

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.  What I
want to do is just access SQL_ASCII and leave UNICODE alone!

Sincerely,

Allan




 
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
uses 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 (select) the table without the truncation and no mention of
UNICODE!
+__________________________________________________________________________+
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. 
What I want to do is just access SQL_ASCII and leave UNICODE alone!
Sincerely,
Allan
Tue, 12 Oct 1999 11:50:35 +0200
"Allan Huffman" <huffmana@ppc.pims.org>
HELP - Accessing SQL_ASCII from Java