Stefan Manegold wrote:
Dear Pawel,
the test that was extended with UTF-8 characters after resolving your bug #2014118 appear to work fine with the code base for the upcoming May2009 release; cf., http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.32.... http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.32....
I also do not recall seeing this test fail with the previous Feb2009 release.
Could you please provide us with detailed instructions including a small example how to reproduce the problems that you experience?
Hi, I hope that that piece of code will help:
import MonetSQLdb testStr = 'us\xc5\x82ugi' con= MonetSQLdb.connect(host = 'localhost', user = 'monetdb',
password = 'monetdb', lang = 'sql', dbname='demo')
cu = con.cursor() cu.execute("CREATE TABLE testtable (testfield varchar(30))")
0
cu.execute("INSERT INTO testtable VALUES ('%s')"%testStr)
1
cu.execute("SELECT * FROM testtable WHERE testfield LIKE
'%s';"%testStr) 1
print cu.fetchall()
[('us\xc5\x82ugi',)]
import pyodbc con2 = pyodbc.connect('DSN=demo') cu2 = con2.cursor() cu2.execute("SELECT * FROM testtable WHERE testfield LIKE
'%s';"%testStr) <pyodbc.Cursor object at 0x00D322F8>
print cu2.fetchall()
[]
cu.execute("DROP TABLE testtable")
0