/// <summary> /// Generate Sql syntax type string for related type /// </summary> /// <param name="sqltype"></param> /// <returns></returns> internal static string ConvertSqlType(SqlVarType sqltype) { switch (sqltype) { case SqlVarType.INT12: return("INT(12)"); case SqlVarType.BOOL: return("TINYINT(4)"); case SqlVarType.ENUM: return("TINYINT(4)"); case SqlVarType.VARCHAR60: return("VARCHAR(60)"); case SqlVarType.VARCHAR120: return("VARCHAR(120)"); case SqlVarType.TEXT: return("TEXT"); case SqlVarType.BLOB: return("BLOB"); case SqlVarType.MEDIUMBLOB: return("MEDIUMBLOB"); case SqlVarType.LONGBLOB: return("LONGBLOB"); case SqlVarType.VARBINARY: return("VARBINARY(32768)"); case SqlVarType.DOUBLE: return("DOUBLE"); default: throw new Exception("Invalid SqlVarType Enum"); } }