NPL_BIBLIO value may be longer than expected
Posted: Wed Nov 01, 2017 5:32 pm
Please note that in the current 2017 Autumn Edition values in attribute NPL_BIBLIO of table TLS214_NPL_PUBLN can be up to 3 800 characters long. If your DB schema is not prepared to hold such longs strings, then you might experience problems when loading the data into your database.
To avoid similar issues in the future, you may want to consider using nvarchar(max) - or the equivalent for your DBMS - as data type for the NPL_BIBLIO attribute.
To avoid similar issues in the future, you may want to consider using nvarchar(max) - or the equivalent for your DBMS - as data type for the NPL_BIBLIO attribute.