[DB-SIG] paramstyles (mysql string length?)

M.-A. Lemburg mal at egenix.com
Wed Apr 19 17:04:49 CEST 2006

Gerhard Häring wrote:
> M.-A. Lemburg wrote:
>> Carsten Haese wrote:
>>> On Wed, 2006-04-19 at 08:24, M.-A. Lemburg wrote:
>>>> I've found the qmark style to be sufficient for everything
>>> I agree. Considering that many modules already support qmark, and those
>>> that currently use 'format'/'pyformat' would have to move to something
>>> else if these are dropped, I'd like to suggest that supporting 'qmark'
>>> style should become a required feature. Modules would be free to also
>>> implement 'named' and/or 'numeric', but supporting 'qmark' should be
>>> mandatory.
>> I'm not sure whether that's easily possible for database modules
>> which rely on different marker mechanisms, e.g. some modules
>> probably use the implicit type information in the pyformat style
>> to find out which method to use for binding variables.
> The ones I know about (pysqlite 1.x, pyPgSQL, psycopg, MySQLdb) all only 
> look at the Python values, not at the pyformat format character for 
> deciding how to bind the variable.

If that's the case, then I suppose supporting qmark style
wouldn't be too much of a problem.

Marc-Andre Lemburg

Professional Python Services directly from the Source  (#1, Apr 19 2006)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

More information about the DB-SIG mailing list