NPL_BIBLIO value may be longer than expected

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

NPL_BIBLIO value may be longer than expected

Post by mkracker » 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.
Martin Kracker / EPO

Post Reply