FYI and for the archive: after some mails clarifying details the problem is solved (see below)
-----Original Message----- From: Greg Robertson [mailto:[EMAIL PROTECTED] Sent: Dienstag, 10. Juni 2003 16:09 To: Koetter, Thomas Theodor Subject: Re: Perl and ODBC - passing large variables Thomas, Thanks for all of your help and clarification. Everything is back on track now!! -- Greg Robertson Senior Engineer Internet Access Engineering EDS On Tue, 10 Jun 2003 15:26:52 +0200 "Koetter, Thomas Theodor" <[EMAIL PROTECTED]> wrote: > Hi Greg > > > As you see the field is set to 1023 which is not a problem as > > I make sure the data fits when it is loaded. However, when I > > need to do a select query I have to modify the string so that > > single quotes (') are in the string twice so that it is > > handled properly. This causes my string to be larger than > > the actual field. For example, if I want to query the following: > > I think following is mixed: > > - double single qoutes in statement literals are handled as a single single qoute. > E.g. > > select * from mytable where sid = 'I''m tired' > > results to (somehow in the kernel) select * from mytable where sid = I'm tired > > - If you use bound parameters (as it is actually done within your perl code), > no special handling of single qoutes are necessary. > > E.g. > > select * from mytable where sid = ? > > sid = "I'm tired"; > bind_param (1,$sid); > > > Bound parameters are taken as there are and therefore cannot be larger than the > table's column. > > > HTH + greetings Thomas > > > ---------------------------------------------- > Dr. Thomas K�tter > SAP DB, SAP Labs Berlin > > > Hurry up, SAP DB is open source www.sapdb.org > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
