/// <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");
}
}
