On Sat, Jan 31, 2004 at 10:06:04PM -0500, Michael Stassen <[EMAIL PROTECTED]> wrote:
> Meanwhile, perhaps a simpler workaround would be to change how you build
> the query in Perl so as to avoid the quotes.
Unfortunately, the heuristic that DBD::mysql uses cannot be changed or
forced. Currently, if the first execution uses an integer, it will never
quote, even when you later use a string and vice versa.
This is a correctness issue, as mysql (properly) treats string
comparisons different to integer comparisons and thus will give
different results.
These problems, however, cannot be solved with the current mysql api, as
(AFAICS), there is no type information. So interfaces to mysql from
languages without strong typing have to second-guess, and do this often
wrong.
The only clean solution to this problem is providing type information, so
DBD::mysql knows that e.g. an integer is expected.
--
-----==- |
----==-- _ |
---==---(_)__ __ ____ __ Marc Lehmann +--
--==---/ / _ \/ // /\ \/ / [EMAIL PROTECTED] |e|
-=====/_/_//_/\_,_/ /_/\_\ XX11-RIPE --+
The choice of a GNU generation |
|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
