As the title states, i´m not sure whether I should/can use a blob field to store text. I need to increase the amount of text in a field to over 255. Is the blob the way to go?

  • 1
    What data format are you using? If string is limited, it probably doesn't support BLOB.
    – Vince
    Dec 4 '13 at 15:53
  • The original field was defined as text 255 with characters Dec 4 '13 at 16:08
  • 1
    What data format? I'm not aware of any modern non-shapefile data source that doesn't support at least 4000.
    – Vince
    Dec 4 '13 at 16:14
  • I thought when I define a field in arcgis as Text I can choose how many characters the field can contain up to 255. I must be very mistaken Dec 4 '13 at 18:16
  • 2
    Are you using SQL Server, Oracle, Postgres, other? Dec 4 '13 at 18:26

As a rule of thumb, BLOB is not the way to go when arbitrary text is desired -- Assuming the contents of a BLOB column is ASCII can become a security issue! Instead, you should be looking at CLOB (UTF-8) or NCLOB (UTF-16) data types (if supported). The fallback (for formats that don't support LOB types) is concatenation of string fields, or ancillary files with data, and the name of the file in the string field.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.