Re: DBI on a pocketPC - preliminary success

2002-12-18 Thread Matt Sergeant
On Wednesday, Dec 18, 2002, at 01:26 Europe/London, Jeff Zucker wrote: Just a preliminary report - thanks to Rainier Keuchel's port of perl to winCE, I now have DBI (PurePerl) and DBD::AnyData doing database read access on my Toshiba e740 (a palm-like handheld running pocketPC on an xScale

Re: Metadata methods in DBI - NUM_PREC_RADIX once or twice?

2002-12-18 Thread Jonathan Leffler
Dear Tim, Errrmmm... Is NUM_PREC_RADIX at 15 or 18 or both? I think it should be at 18 only. I note that the numbers in the type_info_all array/hash are off-by-one compared with the SQLGetTypeInfo() method in ODBC, and SQL_DATA_TYPE appears at 16 in the current version of the man page at

Re: DBI v1.32 - Code generator for $dbh-type_info_all (and Q about $dbh-type_info)

2002-12-18 Thread Steffen Goeldner
Jonathan Leffler wrote: [...] Can anyone explain the bit in the type_info method description (cribbed from the ODBC documentation, I'm sure) about 'ordered by DATA_TYPE first and then by how closely each type maps to the corresponding ODBC SQL data type, closest first'. SQL/CLI defines the

RE: DBI v1.32 - Code generator for $dbh-type_info_all (and Q about $dbh-type_info)

2002-12-18 Thread Jeff Urlwin
[heavily snipped] It takes the output from DBD::ODBC's type_info_all method and maps it writes a new copy of the hash. I actually wrote it to handle the extra attributes you documented, and was pleasantly surprised to find DBD::ODBC 1.01 already providing the extra attributes (possibly

Re: DBI v1.32 - Code generator for $dbh-type_info_all (and Q about $dbh-type_info)

2002-12-18 Thread martin
On 18-Dec-2002 Steffen Goeldner wrote: Jonathan Leffler wrote: [...] Can anyone explain the bit in the type_info method description (cribbed from the ODBC documentation, I'm sure) about 'ordered by DATA_TYPE first and then by how closely each type maps to the corresponding ODBC SQL data

Re: DBI on a pocketPC - preliminary success

2002-12-18 Thread Jeff Zucker
Hi Matt, It'd be cool to see if DBD::SQLite worked there - then you'd have a fully transaction aware database on a handheld! At the moment I don't have a compiler or SDK for the pocketPC so I'm just using other people's prebuilt binaries plus pure perl modules (don't even have some basics

Fwd: Unicode in DBD::Pg

2002-12-18 Thread David Wheeler
DBI-Dev'ers, Below please find a message I forward from dbi-users. Although I haven't noticed a problem with Unicode and DBD::Pg, but this message did lead me to wonder if setting the UTF8 flag is something that we may actually be needing to do in the drivers, and if so, is this the right way