=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2014-09-15 20:06:58 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2014-09-19 14:10:47 +0000 @@ -736,6 +736,9 @@ executeSql( "alter table indicator drop column sortorder" ); executeSql( "alter table dataset drop column sortorder" ); + executeSql( "alter table datavalue alter column value type character varying" ); + executeSql( "alter table datavalue alter column comment type character varying" ); + upgradeDataValuesWithAttributeOptionCombo(); upgradeCompleteDataSetRegistrationsWithAttributeOptionCombo(); upgradeMapViewsToAnalyticalObject(); === modified file 'dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/ValidationUtils.java' --- dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/ValidationUtils.java 2014-07-21 09:45:25 +0000 +++ dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/ValidationUtils.java 2014-09-19 14:10:47 +0000 @@ -28,21 +28,29 @@ * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ +import static org.hisp.dhis.dataelement.DataElement.AGGREGATION_OPERATOR_AVERAGE; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_BOOL; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_DATE; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_INT; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_NEGATIVE_INT; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_NUMBER; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_PERCENTAGE; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_POSITIVE_INT; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_TRUE_ONLY; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_UNIT_INTERVAL; +import static org.hisp.dhis.dataelement.DataElement.VALUE_TYPE_ZERO_OR_POSITIVE_INT; + +import java.awt.geom.Point2D; +import java.util.Locale; +import java.util.regex.Matcher; +import java.util.regex.Pattern; + import org.apache.commons.validator.routines.DateValidator; import org.apache.commons.validator.routines.EmailValidator; import org.apache.commons.validator.routines.UrlValidator; import org.hisp.dhis.dataelement.DataElement; import org.hisp.dhis.datavalue.DataValue; -import java.awt.geom.Point2D; -import java.util.Arrays; -import java.util.List; -import java.util.Locale; -import java.util.regex.Matcher; -import java.util.regex.Pattern; - -import static org.hisp.dhis.dataelement.DataElement.*; - /** * @author Lars Helge Overland * @version $Id$ @@ -244,7 +252,6 @@ * *