[rt-devel] RT 2.0.14-pre1
jesse at bestpractical.com
Mon Jul 1 13:32:12 EDT 2002
> Actually, the limit is 100 characters, for transactions.data. Older
> PostgreSQL versions silently truncated overlong values for VARCHAR
> columns, but newer ones (since 7.2 or so) don't.
Urk. they changed that behavior?
> Looks like I have to restructure the whole database. :-/
> Jesse, maybe it's a good idea to use TEXT fields instead of VARCHAR
> fields when creating new PostgreSQL databases? According to the
> documentation, there is no performance difference.
Hm. are there no other tradeoffs, or are texts now just superlong varchars?
> Florian Weimer Weimer at CERT.Uni-Stuttgart.DE
> University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/
> RUS-CERT fax +49-711-685-5898
> rt-devel mailing list
> rt-devel at lists.fsck.com
http://www.bestpractical.com/products/rt -- Trouble Ticketing. Free.
More information about the Rt-devel