I've go a report of a problem with Microsoft SQL Server 9.0: I've a
SQLObject database structure which uses a number of UnicodeCol
columns without length limit.
In other database servers - MySQL, PostgreSQL, ... - these
columns are correctly mapped to TEXT types, while in SQL Server
a VARCHAR(4000) is used.
Looks like this choice is forced in the SOStringLikeCol._mssqlType()
method, in the col.py file.
My questions are:
1. why this choice?
Performances, I assume, but it seems a bit rude to me: I expected
to get an unlimited field.
2. any work-around?
Modifying SQLObject is not an option: mine is a free software
application, and I have no control of the installation base.
Davide Alberani <davide.alberani _at_
gmail.com> [PGP KeyID: 0x465BFD47]