I have a SQL server table that has information that I would like to join to a shapefile, but a couple of the fields exceed the maximum number of characters allowed for a shapefile in a field (one field has 300 and the other 500).
It is a python script I am trying to compile, and when using the add join tool it gave me an error stating the fields were too large. Can anyone suggest how I can get this information over to my shapefile? Would creating fields in the shapefile and then calculating values work or would that error? I would be happy to only get the maximum number of characters allowed in the field for a shapefile (254?).
Hope that makes sense, any advice would be great!