On Sun, Feb 01, 2004 at 02:43:08PM -0800, Jeff Zucker wrote: > With hopes that I know why you're asking (yuck, concat multiple 255 fields), > I get these results from the test below. Note that my version > of MySQL (Ver 8.23 Distrib 3.23.55, for Win95/Win98 on i32 > with DBD::mysql 2.9002) does *not* behave the way yours does: > > ok - DBD::AnyData: > ok - DBD::CSV: > ok - DBD::SQLite:mi > ok - DBD::PgPP:dbname=mi;host=localhost > bad - DBD::mysql:database=mi
Ah, I'd recently upgraded. The docs say "From version 4.1.0, if the M value specified is greater than 255, the column type is converted to TEXT." [Sigh] > bad - DBD::ODBC:msaccess No surprise. [Sigh] Oh well. We're stuck with the yuck. But it does serve as a powerful illustration of the problems of trying to be portable across databases. It's 2004 and we can't even write VARCHAR(1024). How sad is that? Tim. p.s. Please don't bother answering that rhetorical question!
