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