perhaps this helps http://www.webservertalk.com/archive308-2007-3-1836413.html
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of vha > Sent: Sunday, February 10, 2008 7:55 PM > To: pgsql-bugs@postgresql.org > Subject: [BUGS] BUG #3951: SELECT ... WHERE Param = ? does > not work if Param is of type bytea > > > The following bug has been logged online: > > Bug reference: 3951 > Logged by: vha > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 > Operating system: Windows XP SP2 > Description: SELECT ... WHERE Param = ? does not work > if Param is of > type bytea > Details: > > I have a table with one of the columns of type BYTEA > containing GUIDs (16 bytes of data). > > The data of the column is specified using > SQLBindParameter(hstmt, nCol, SQL_PARAM_INPUT, SQL_C_BINARY, > SQL_BINARY, 16, 0, theGUID, 16, &ptr). > > This works fine to insert the data using "INSERT ... VALUES > ?", but retrieving the data using "SELECT ... WHERE Param = > ?" doesn't work: nothing is returned. > > Am I doing something wrong or is this a bug? > > BTW. This code works without any problem on MS SQL 2000, MS > SQL 2005, Oracle and MySQL. > > > vha > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] > so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
