Will BULK INSERT truncate trailing spaces to fit in smaller field?
Posted on 2007-08-09
I have a three-byte character field I'd like to BULK INSERT into a two-byte character table field. I'll be massaging the data beforehand such that only the first two bytes in the text file will actually be used, and the third byte will always be blank. Does anyone know if BULK INSERT will be smart enough to do the load, ignoring the third byte? (I don't care if it issues a warning...)