[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
eGenix.com
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