On 04-Feb-2002 [EMAIL PROTECTED] wrote:
> I installed DBD::ODBC 0.32 on a machine a few weeks ago and unnotticed by
> myself (while a colleague was away on holiday) some of his cron jobs using
> Perl
> and DBD::ODBC were failing. These used to work. It appears it was the change
> in
> dbd_preparse() to use " as the quote chr instead of '. I notice that
> DBD::ODBC
> 0.33_01 test release has the ' back again but in addition to ".
>
> Can this not be a call to SQLGetInfo for SQL_IDENTIFIER_QUOTE which is
> getinfo
> number 29?
>
> Hopefully, this would then work for any identifier quote chr.
In addition to the above, I have discovered some SQL containing ' can confuse
the preparse method.
e.g.
assuming
create table mytable(a char(100))
insert into mytable values('''2001-02-15 01:02:03')
is changed to
insert into mjep1 values('''2001-02-15 01??')
incorrectly. With SQL Server you use '' to escape a '.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
