Bookfinder may return title that's too long for title field in database

Description

The result is an error in the logs. May also affect the display. Here's an example: 9780529064844

Activity

Norhal El Halwagy October 27, 2008 at 8:33 AM

checked and verified.

Jim Eng October 17, 2008 at 2:29 PM

Please assign to Norhal for verification.

Jim Eng October 17, 2008 at 2:28 PM

This is fixed in version tbook-0.8_RC05.

Jim Eng October 17, 2008 at 2:27 PM

We will truncate titles, lists of authors, and other fields if their values are too big to go into the database. For very long fields (like 255 characters max), we will attempt to truncate at the last space character such that we can add an ellipsis ("...") at that point and still save the value. However, if truncating at a space would shorten the string by more than 10 percent, we will instead just lop off enough characters to add the ellipsis and still fit in the space allowed. For very short strings, we will just lop off excess characters without adding an ellipsis.

This behavior can be observed in version tbook-0.8_RC05. Here's a example, based on the value shown above for ISBN 9780875101774:

The Holy Bible, containing the Old and New Testaments : translated out of the original tongues, and with the former translations diligently compared and revised, by His Majesty's special command : appointed to be read in churches : authorized King ...

Sean Michael Demonner October 16, 2008 at 11:56 AM

I think this is a Blocker since there's no way for a user to manually truncate the title and therefore they can't offer the book = dead in the water.

We need truncation of really long titles.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created October 16, 2008 at 10:54 AM
Updated October 27, 2008 at 8:33 AM
Resolved October 17, 2008 at 2:28 PM