Hi,
although I'm programming a lot I don't use DBI every day.
So, being more familar with perl itself, C or
SGML-Standards, I found a problem that unfortunately costed
me a whole evening to identify and I think it is some kind
of bug. I expected that both of the following expressions
should have identical results:
$myquery = "SELECT * FROM MyTable;" ;
$myquery = "SELECT * FROM MyTable; ";
But - at least on my (sorry!) Windows-PC with a
Win-32-version of Perl - they don't have! The first
expression returns the expected result table, the second one
leads to an empty table! The reason for that is the space at
the end of the string that is going to be passed to DBI! As
far as I know, according to all conventions of programming,
the space should be ignored by DBI. Like Perl itself ignores
the space at the end of the first example.
Is this a bug? Is it just a problem of the win-version? Or
is there any reason or purpose for that.
Thank you and regards
Thomas Hillebrand
