Thread: RE: [HACKERS] Re: PostgreSQL Help

RE: [HACKERS] Re: PostgreSQL Help

From
Peter Mount
Date:
The column width bug was fixed in 6.5.2, so it should return the correct
result. However, the 6.5.2 driver won't work with 6.2.1, as they use a
different protocol.

As for MultiByte strings, you need to compile the backend to accept them
(someone correct me if I'm wrong here).

Peter

-- 
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.



-----Original Message-----
From: wieck@debis.com [mailto:wieck@debis.com]
Sent: 07 October 1999 15:11
To: huffmana@ppc.pims.org
Cc: pgsql-hackers@postgreSQL.org
Subject: [HACKERS] Re: PostgreSQL Help


>
> Dear Jan,
   Don't  know  why  you're asking me - I'm not involved in JDBC   nor am I in the multibyte stuff.
   I've included the hackers list into  this  response  -  maybe   someone else can comment on it?


Jan

>
> I am using Java with JDBC (from a PC using VisualCafe Database
Edition)
> to run an application using PostgreSQL 6.2.1 (on a Sparc).  Everything
> is running fine except for a string problem. The Postmaster says (when
> loading data from the database into the text fields of the GUI):
> "ERROR: MultiByte strings (MB) must be enabled to use this function"
>
> The DOS prompt (where the Visual Cafe development environment runs an
> Applet) tells me:
> "The maximum width size for column 3 is: 17"
>
> And this is for a varchar(43) field.  When I enter a string into the
> column from my Java text field I get the diagnostic:
> "Invalid value for the column: product_name"
>
> I figure that all I have to do is enable MB but I can't find it.  If
you
> have not encountered this problem before, do you know of a user group
> where I can post a question.
>
> Sincerely,
>
> Allan in Belgique
>
> Allan@ppc.pims.org
>
>
>


--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #



************


Re: [HACKERS] Re: PostgreSQL Help

From
Tatsuo Ishii
Date:
Peter,

> As for MultiByte strings, you need to compile the backend to accept them
> (someone correct me if I'm wrong here).

I suspect he is not running PostgreSQL 6.2.1 becasue the multibyte
capability has been introduced since 6.3.2. Anyway, the particular
message:
"ERROR: MultiByte strings (MB) must be enabled to use this function"

is raised if getdatabaseencoding() is called and the backend is not
compiled with MB option as you said. But the question is: does
the standard PostgreSQL JDBC driver call getdatabaseencoding()?
---
Tatsuo Ishii