On 17-Jan-10, at 8:36 PM, Vikram Noel Ambrose wrote: > Markus Hoenicka wrote: >> Vikram Noel Ambrose writes: >>> Either mysql is telling libdbi that the field is binary or libdbi is >>> getting confused somewhere. >>> >> >> Could you please insert a call to dbi_result_get_field_type_idx() to >> see what mysql thinks this is? >> > > It returns type 4. Which is DBI_TYPE_BINARY in my dbi.h > > I don't have another db to test with at the moment, but does this > return > type 4 when using other drivers on a column declared varchar with > binary > collation?
This is probably driver dependent. IMHO the first check would be to see if the unexpected reversion to binary type is occurring within libdbi or in libmysqlclient (or mysqld). --Toby > > It should always be type 3 (DBI_TYPE_STRING). > > Vikram. > > ---------------------------------------------------------------------- > -------- > Throughout its 18-year history, RSA Conference consistently > attracts the > world's best and brightest in the field, creating opportunities for > Conference > attendees to learn about information security's most important > issues through > interactions with peers, luminaries and emerging and established > companies. > http://p.sf.net/sfu/rsaconf-dev2dev > _______________________________________________ > libdbi-users mailing list > libdbi-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/libdbi-users ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users