Re: bcp_bind vartype = 0
craigberry <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Jun 21, 2010, at 01:03 PM, Gil Rohde <[email protected]> wrote: > In Sybase, setting the bcp_bind vartype parameter to 0 tells it not to perform any conversion on the datatype. FWIW, Microsoft documents the same behavior: http://msdn.microsoft.com/en-us/library/ms131401.aspx > With freetds this seems to cause a failure since it attempts to convert it with dbconvert and doesn't recognize a source type of 0. > > Is this a known and recognized difference or bug? It looks like one way to handle this is to modify dbconvert to treat a source type of 0 as the same as the dest type. It looks like a bug. dbconvert() does have special handling for the source type and destination type being the same, and since this is really a subset of that, it could probably be added to it. It might be as simple as saying if (!srctype) srctype = desttype; somewhere near the top of dbconvert(). _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds