On Thu, Nov 22, 2007 at 05:59:09PM +0100, Markus Gritsch wrote:
Hi,
I would like to know how encoding related issues are handles in MonetDB. For example, when I run the following Python script
# -*- coding: utf-8 -*-
import MonetSQLdb
x = MonetSQLdb.connect(host = 'localhost', user = 'voc', password = 'voc', lang = 'sql')
c = x.cursor()
c.execute('DROP TABLE test') c.execute('CREATE TABLE test(id int, name varchar(20))') c.execute('INSERT INTO test (id, name) VALUES (%s, %s)', (0, 'ä ö ü'))
c.close() x.close()
and then look at the inserted data using DbVisualizer I get
ä ö ü How does it look with mclient -lsql -s "select * from test;" ?
The strings should be cast to utf8 by the client side.
in the 'name' column. When I try to edit the value in the DbVisualizer, I get an error message
"unexpected end of input". (The SQL statements reads update voc.test set name = 'ö' where id = 0).
Is this a JDBC driver problem? When I connect to an MySQL database with the MySQL JDBC driver included in DbVisualizer I can insert arbitrary characters, and they get properly displayed in the GUI.
I'm not sure. Which jdbc driver version do you have? Niels
Kind regards, 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