nikosv wrote: > thanks Roy.the file is less than 32K so varchar would be fine. > As a side note,why doesn't Ingres support the native XML type? Could you use JSON instead? Ingres has fairly extensive support for JSON. https://docs.actian.com/actianx/11.2/index.html#page/SQLRef/Working_with_JSON_Data.htm# Roy