Re: [MonetDB-users] Question about used Encoding

On Thu, Nov 22, 2007 at 09:52:51PM +0100, Niels Nes wrote:

On Thu, Nov 22, 2007 at 09:12:22PM +0100, Markus Gritsch wrote:

...

On Nov 22, 2007 8:49 PM, Niels Nes wrote:

...

How does it look with mclient -lsql -s "select * from test;" ?

Alas, since I am on Windows XP, the cmd.exe is not UTF-8 aware, so I don't know if this helps much. However, I have made a screenshot which shows the output. It is attached as cmd.png.

...

I'm not sure. Which jdbc driver version do you have?

I use MonetDB5-SQL-Installer-i386-20071017.msi which contains monetdb-1.6-jdbc.jar. DbVisualizer is version 6.0.6.

The attached logs were produced by connecting, running the query

SELECT * FROM test

and disconnecting. I hope this helps. The results seem indeed incorrect. Which would indicate that the insert allready didn't do the right job. So it atleast seems that the bug is in python monetdb interface not in jdbc. I'll have to look into it. Could you try the jdbc*jar from www.cwi.nl/~fabian/troep/, I hope its not giving the 'unexpected end of data' problem.

Found the bug. In the file MonetSQLdb/converters.py, latin1 should be changed into UTF-8. Niels

Niels

...

Markus

...

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

--

Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl