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
ä ö ü
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.
Kind regards, Markus