[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:  new                              
   Priority:  major           |   Milestone:  3.6.0                            
  Component:  MySQL Provider  |     Version:                                   
   Severity:  3               |    Keywords:  String Data Property varchar text
External_id:                  |  
------------------------------+---------------------------------------------

Comment(by brentrobinson):

 Revision: 5687
 Author: brentrobinson
 Date: 1:25:43 PM, Tuesday, September 28, 2010
 Message:
 Ticket#701: Modified ApplySchema implementation to create varchar columns
 for string data properties with default values, when the length is 512
 characters or less. The previous threshold was 255 characters. The
 threshold is still 255 for properties without default values. This is a
 cautious first step that allows the MySQL provider to handle larger string
 properties that have default values (see ticket for more details). A
 larger fix might be done in a later submission to raise the threshold
 higher and also raise it for properties without defaults.
 ----
 Modified :
 /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnChar.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnChar.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/DbObject.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Mgr.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Mgr.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlFdoApplySchemaTest.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlFdoApplySchemaTest.h

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