Hi @asmecher
after I succeeded in delivering all volume data to Crossref (see here: Export all avail data to Crossref) I realise that the number column MUST NOT exceed 32 chars - that is: including special chars like those German umlauts (ä, ö, ü). Even after I set the maxlength of the column to varchar(32) in the database I received error messages from Crossref. Just from counting the chars it means that (ä, ö, ü) count double. This also means that their server (probably handle.net) might not operate in utf8.
This is the error msg:
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO atypon.citation_info (CITATIONID, JOURNALCITEID, BOOKCITEID, SERIESTITLEID, MISSPELLINGID, SUBMISSIONID, VERSION, YEAR, VOLUME, ISSUE, SUPPLEMENT, PAGE, AUTHOR, COMPONENTNUMBER, EDITIONNUMBER, OWNERPREFIX, ARTICLETITLE, SEQUENCENUMBER, TYPE, DOI, MDCONFLICTID, PAGEMOD, SRCTYPE, ORIGPAGE, LASTPAGE, PUBMONTH, PUBDAY, CONFNAMEID, INSTCITEID, FORCEDALIASID, ALIASID, SRCSUBTYPE, LASTUPDATE, REFSUBMISSIONID, MASK) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; ORA-12899: value too large for column “ATYPON”.“CITATION_INFO”.“ISSUE” (actual: 33, maximum: 32)
; nested exception is java.sql.SQLException: ORA-12899: value too large for column “ATYPON”.“CITATION_INFO”.“ISSUE” (actual: 33, maximum: 32)