Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question
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 –  Robert Buckley 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 –  Robert Buckley Dec 4 '13 at 18:16
2  
Are you using SQL Server, Oracle, Postgres, other? –  RyanDalton Dec 4 '13 at 18:26

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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