Pawel, could you pleas file a new bug report with the details given below? Please include also a reference to your previous bug report #2014118. Thanks! Stefan On Thu, May 28, 2009 at 04:03:56PM +0200, Pawel Lewicki wrote:
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)
print cu2.fetchall() [] cu.execute("DROP TABLE testtable") 0 ------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp as they present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |