The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 13, 2009
Filed:
Jan. 23, 2006
Yen-fu Chen, Austin, TX (US);
John H. Bosma, Cedar Park, TX (US);
John W. Dunsmoir, Round Rock, TX (US);
Venkatesan Ramamoorthy, Round Rock, TX (US);
Mei Yang Selvage, Pocatello, ID (US);
Yen-Fu Chen, Austin, TX (US);
John H. Bosma, Cedar Park, TX (US);
John W. Dunsmoir, Round Rock, TX (US);
Venkatesan Ramamoorthy, Round Rock, TX (US);
Mei Yang Selvage, Pocatello, ID (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A system and method for preventing user-input text strings of illegal lengths from being submitted to a database where, for each character in the string, a character length is determined in quantities of digital units of storage according to an encoding schema, the character lengths are accumulated into a total string length, also measured in digital units of storage, and the total string length is compared to one or more database input field requirements such as non-null and maximum length specifications. If a limit is not met, the system and method are suitably disposed in a manner to block or prevent submission of the user-input string to the database. Overflow sub-strings are extracted and stored from input strings which exceed the input length limit, and are further processed to yield additional storage and resource allocation.