FAQ

On Mon, Aug 02, 2004 at 09:40:17PM -0700, Jonathan Leffler wrote:
DBD::Informix 0.95 introduced the internal tables function; no-one
should still be using any earlier versions of DBD::Informix than
1.00.PC1, so the 'sad hack' can go - especially since it actually
doesn't work reliably for Informix anyway.
Yeap. That's what I thought. Hence the 'todo' list entry. Thanks for
the confirmation.
I note that the DBI (v1.42 RC1, but I don't think it changed) version
does not handle schema names containing quotes:

CREATE TABLE """""".blanketyblank (...);

This is a valid table called blanketyblank owned by (belonging to
schema) double-quote, double-quote in an ISO-compliant SQL database.
Granted, that's kinda esoteric, but if you're worrying about quoting
stuff just in case, hadn't you better worry about all the cases that
might just occur?
Of course, and it seems to work just fine:

$ perl -w -MDBI -e 'warn DBI->connect("dbi:NullP:")->quote_identifier(undef, q{""}, "blanketyblank")'
""""""."blanketyblank" at -e line 1.

Tim.

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
groupdbi-users @
categoriesperl
postedAug 3, '04 at 4:40a
activeAug 3, '04 at 9:32a
posts2
users2
websitedbi.perl.org

2 users in discussion

Tim Bunce: 1 post Jonathan Leffler: 1 post

People

Translate

site design / logo © 2022 Grokbase