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
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

Frank Steiner - May 18, 2009 - 12:55

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.2001

So this should be sth. like length 80 or so I guess...

#2

rjerome - May 28, 2009 - 21:34

I'm going to change everything currently less than 128 to varchar(128)

That should resolve your issues.

Ron

#3

rjerome - May 29, 2009 - 01:21
Status:active» fixed

Committed to CVS.

Ron.

#4

Frank Steiner - June 3, 2009 - 14:55

thanks!

#5

System Message - June 17, 2009 - 15:00
Status:fixed» closed

Automatically closed -- issue fixed for 2 weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.