[MonetDB-users] Portuguese Characters

Fabian Groffen Fabian.Groffen at cwi.nl
Tue Dec 4 13:32:23 CET 2007

On 03-12-2007 21:04:44 +0100, Fabian Groffen wrote:
> On 03-12-2007 11:14:55 -0800, Paulo Jorge Dias wrote:
> > Using a java program with jdbc:
> > 
> > D:\MonetDB5>java Concelho
> > java.sql.SQLException: unexpected end of input
> > 
> > Is there any way to get this running?
> Very interesting.  This is an encoding problem as seen before on this
> list.  However this time also mclient is involved.  Is it possible for
> you to send me a snippet of the data you are loading that makes this
> fail?  Or attach it to a bug?

After several hours of "fun" with Windows XP Sjoerd and I fixed a bug
present in both the Python and Java libraries as they didn't send and
receive UTF-8 byte sequences to and from the server if the current
locale wasn't UTF-8.  We fixed this now, avoiding the "unexpected end of
input" error.

With the latest JDBC driver (Canephora_p2/MCL 1.2) you can now store and
receive non-regular characters from Windows, however they are not stored
correctly in the database.  This is not a problem as long as you don't
use another (non-windows) client to retrieve the data.

It is hard to fix above issue, because Windows reports locale cp1252 to
the application (Python, Java) whereas in the command line it really is
cp743 (DOS).

More information about the users-list mailing list