I am trying to populate an HDF5 file using PyTables with data from SQL
database.  One of the columns of this table is defined as 'VARCHAR(MAX)'.  I
would like to be able to do something like:

class NewsItems(tables.IsDescription):
    item_id = tables.Int32Col()
    isodatetime = tables.StringCol(26)
    newstext = tables.StringCol(MAX)  ** obviously won't work

In my database, the length of the strings in the varchar(max) column varries
from ~2000 to ~60000.  If I simply set the 'newstext' variable in the above
class definition to be slightly larger than the maximum length then the file
that I create is unacceptably large (over 6GB).

I am a new user to PyTables, but I have read the documentation and have not
been able to answer my own question yet.  Any thoughts?

Thanks in advance.

Scott
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Pytables-users mailing list
Pytables-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pytables-users

Reply via email to