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?
import MonetSQLdb testStr = 'us\xc5\x82ugi' con= MonetSQLdb.connect(host = 'localhost', user = 'monetdb',
Hi, I hope that that piece of code will help: 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)
print cu2.fetchall() [] cu.execute("DROP TABLE testtable") 0