varchar(max) 2 GB ??????


  • I have various shapes in WKT, going into a varchar(max) column, but for some reason they are being truncated after about 1400 geometric nodes. It affects maybe 60+ records., out of a total of 12,000 imported. 

    The entire txt import file itself was only 68MB (all 12,000)!

    How on earth have I reached a 2gb txt max in a varchar(max) for 1 record/column. I tried adding text to the affected columns and got a truncation warning, so i know the problem lies w/in the db engine/schema (not an import issue). 

    The craziest part is I get no truncation warning to the Destination Column, but it's definitely 'overloaded'.

    Any Clues, 



    Monday, November 04, 2013 4:53 AM


All replies