H.Merijn Brand wrote:
Where do these $sql_create's come from?
From a script I'm writing to scrape the dataset to be used in
_Programming_the_Perl_DBI 2nd edition.
If it wehere user code, it'd probably
better be
$sql_create =~ s/\bVARCHAR\s*(1024)/TEXT/gi if $dsn =~ /dbi:(mysql|unify)/i;
Yep, thanks, mine were sloppy.
ALTER TABLE is supported in Unify as of Unify-8.2, but the syntax is not 100%
the same as Oracle (but who'd expected that in a world full of standards)
s/full of/lacking adherence to/; :-)
--
Jeff