On Sep 23, 2008, at 4:24 PM, Rick Morrison wrote:
> class MSBinary(sqltypes.Binary): > def bind_processor(self, dialect): > def process(value): > return '0x' + value.encode('hex') > return process > > ...the issue is that the emitted value is getting quoted somewhere > after the type conversion: > > INSERT INTO binary_table VALUES(...., '0x6df02da', ...) > > but MSSQL's parser can recognize the '0x' prefix and wants the value > unquoted: > > INSERT INTO binary_table VALUES(...., 0x6df02da, ...) > > So how do I get the Dialect to drop the quoting behavior for the > return from bind_processor() ? SQLA doesn't quote bind values. It passes bind parameters, so this is likely pyodbc assigning quoting. The first step here is to get a full binary round trip working with only pyodbc, no SQLA in use. The dialect can then be adjusted to do whatever is needed in that regard. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---