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.32.d.1-Windows5.1/src_odbc_samples/odbcsample1.out.00.html
> > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.32.32.d.1-Windows5.1/src_odbc_samples/odbcsample1.err.00.html
> >
> > 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
> >>>
>
>
> ------------------------------------------------------------------------------
> 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@...
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
>
--
| Dr. Stefan Manegold | mailto:Stefan.Manegold@... |
| 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 |
|