Tickets :: [#7146] Create MySQL 5 SQL scripts using VARCHAR(MAX)

Summary	Create MySQL 5 SQL scripts using VARCHAR(MAX)
Queue	Horde Base
Queue Version	Git master
Type	Enhancement
State	Rejected
Priority	1. Low
Owners
Requester	chuck (at) horde (dot) org
Created	08/02/2008 (6155 days ago)
Due
Updated	07/28/2011 (5065 days ago)
Assigned
Resolved	07/28/2011 (5065 days ago)
Milestone
Patch	No

07/28/2011 01:25:10 PM	Jan Schneider	Comment #3 State ⇒ Rejected	Reply to this comment
I guess not.

06/27/2011 10:19:45 PM	Jan Schneider	Comment #2 State ⇒ Feedback Version ⇒ Git master	Reply to this comment
Is this still something we want in Horde_Db, given that it's hard to chose between varchar(max) and blob in migration while still keep it compatible with other DBs?

08/02/2008 11:10:15 PM	Chuck Hagenbuch	Comment #1 Priority ⇒ 1. Low Patch ⇒ No Milestone ⇒ Queue ⇒ Horde Base Summary ⇒ Create MySQL 5 SQL scripts using VARCHAR(MAX) Type ⇒ Enhancement State ⇒ Accepted	Reply to this comment
A number of places where we currently use TEXT fields in database tables don't really need BLOB-size data size - horde_perms.perm_data for example. With MySQL 5, VARCHARs can be nearly 64k, which is plenty, and per http://arjen-lentz.livejournal.com/126316.html, will prevent some temp table usage which will speed up permissions queries. We should create db-specific fields that make use of that - .mysql5.sql for example - for relevant databases.