issn and section fields too small for patent type
Frank Steiner - May 18, 2009 - 12:40
| Project: | Bibliography Module |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Hi Ron,
as every patent number can have it's own date when it was granted, it's not unusual to usw sth. like
International Patent Number PCT/EP 99/01008 (Feb 10, 1999)
Patent Number US 6,713,256 B1 (Mar 30, 2004)biblio_issn with length 24 and biblio_section with length 10 don't accept such long strings. Would you mind to increase those in the DB and the edit form to e.g. 40?

#1
Uh, forgot biblio_number, that is even worse. It's user for the application number, which is quite long. E.g.:
PCT Patent application, European patent office 10.08.2001So this should be sth. like length 80 or so I guess...
#2
I'm going to change everything currently less than 128 to varchar(128)
That should resolve your issues.
Ron
#3
Committed to CVS.
Ron.
#4
thanks!
#5
Automatically closed -- issue fixed for 2 weeks with no activity.