[fdo-trac] #701: MySQL: use varchar for longer string properties

[FDO]

#701: MySQL: use varchar for longer string properties
-----------------------------------------------+----------------------------
 Reporter:  brentrobinson                      |         Owner:  brentrobinson
     Type:  enhancement                        |        Status:  closed       
 Priority:  major                              |     Milestone:  3.6.0        
Component:  MySQL Provider                     |       Version:               
 Severity:  3                                  |    Resolution:  fixed        
 Keywords:  String Data Property varchar text  |   External_id:               
-----------------------------------------------+----------------------------
Changes (by brentrobinson):

  * status:  assigned => closed
  * resolution:  => fixed


Comment:

 Revision: 5736
 Author: brentrobinson
 Date: 1:20:30 PM, Monday, October 04, 2010
 Message:
 Ticket#701: Continuation of revision 5687 to allow more string properties
 to be represented as varchar columns. Before a table is created or
 modified, the total row size is check. If it is under the maximum row size
 then all new string columns are assigned the varchar type. Otherwise, the
 larger string columns (that do not have a default value) are assigned the
 text type until the row size is under the maximum.
 ----
 Modified :
 /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnChar.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnGeom.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Database.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Database.h
 Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Table.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Table.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Database.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Database.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Database.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Database.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Database.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Database.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/LogicalPhysicalBender.xslt
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlFdoApplySchemaTest.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlFdoApplySchemaTest.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlSchemaMgrTests.cpp
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Database.h
 Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Database.cpp

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/701#comment:3>
FDO <http://fdo.osgeo.org/>
Feature Data Objects