Re: Problem with odbc and Sql Server

2006-05-21 Thread Frank Millman
Frank Millman wrote: > Hi all > > I have found a problem using MS Sql Server connecting via the odbc > module from python-win32. > > Assume a table 't1' with a column 'c1' of type varchar(10). > > >From Python, set c1 to an empty string - > cur.execute("UPDATE t1 SET c1 = ?",['']) > > The resu

Re: Problem with odbc and Sql Server

2006-05-21 Thread Andrew MacIntyre
Frank Millman wrote: > Assume a table 't1' with a column 'c1' of type varchar(10). > >>From Python, set c1 to an empty string - > cur.execute("UPDATE t1 SET c1 = ?",['']) > > The result is that c1 is actually set to a string of 10 spaces. > > If I execute the command without using parameter