On 03-12-2007 21:04:44 +0100, Fabian Groffen wrote:
On 03-12-2007 11:14:55 -0800, Paulo Jorge Dias wrote: [snip]
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).