[Za-pm] Databases & Perl

Tielman de Villiers tvilliers at lastminute.com
Fri May 30 12:03:02 PDT 2008


On 2008-05-30 16:38, "Ian Balchin" <aesop at fables.co.za> wrote:

> The problem is that the Pdox normal field length max is 256 characters.
> There are 'memo' fields that will take as much as you like, but export from
> Memo fields and import into Memo fields (say from/as a delimited format)
> takes place at the 256 character level, or is even not supported - at least
> not 
> without special code. ie you can write up several k of data but you are likely
> to get only 256 chars in or out.
> 
> If I was looking at one of the SQL databases, is this a likely scenario for
> them as well?

No. You can use VARCHAR or TEXT fields to store more than 255 characters.
See:

http://dev.mysql.com/doc/refman/5.0/en/char.html
http://www.postgresql.org/docs/8.3/static/datatype-character.html
http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DB
A_25.shtml
http://mc-computing.com/Databases/FieldTypes.html


--tielman






More information about the Za-pm mailing list