Issue 18890 - [OOo Writer Biblio DB] increase URL field length definition
Summary: [OOo Writer Biblio DB] increase URL field length definition
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: tom
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-01 14:47 UTC by Unknown
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-09-01 14:47:23 UTC 
Hello,
 
Issue: Ihe "URL" field in the Biblio Database is defined as VARCHAR with maximum
length of 50 characters. While 50 chars might eventually sound much, in practice
it is far to less, even for relatively "short" URLs.

Another problem is that I only did recognized this issue because after a while I
saw that all my URLs got "mysteriously" cut after saving an entry. Then I
realized that one can enter but no paste URLs which are longer than the defined
length.
 
Proposal: Change default database definition to VARCHAR 265 or similar. (while
someone is at it, maybe also have a look at the other definitions... ;-))
Optionally how about a length check and a user notification "The value entered
is too long to be pasted into this field" or similar?
 
Thanks. Regards,
Daniel

PS: I'll put this down to P4... ;-)
Comment 1 Frank Schönheit 2003-09-01 15:52:35 UTC 
assigning to the engineer how is responsible for providing the
pre-installed Bibliography.

For the validation issue (indicating that the entered value is
'invalid', instead of silently cutting it): There are some plans for
this for 2.0, anyway ...

fs->tv: Not sure, but IMO 256 doesn't sound too bad. Indeed there have
been other complaints about field lengths, so I second the idea to
verify them all :)
Comment 2 tom 2003-09-15 11:03:47 UTC 
Jup, there is another issue (i16268) that is similar to this. I'll fix
them both together for OO.o 2.0.
Comment 3 tom 2003-09-15 11:05:56 UTC 
I just checked the other bug. I think I will fix it for OO.o 1.1.1
already :)
Comment 4 Unknown 2003-09-15 13:56:28 UTC 
Great. :-)

(Maybe I should add that when, above, I meant, that one can enter urls
that are longer than allowed, this seems only to be true for the
"table view" and not for the input fields in the form just below. But
anyway that was just a sideeffect, the real issue was the url field
beeing to short...)

Oh, and thanks for such a great piece of Software! I am just about to
happily finish my diploma thesis with OOo Writer... :-))

Daniel

PS: Whops, just checked, seems this issue is indeed more or less a
duplicate of #16268.
Comment 5 tom 2003-09-29 13:59:52 UTC 
Will be fixed for OOo 1.1.1
Comment 6 marc.neumann 2003-10-16 11:20:52 UTC 
"According to the OpenOffice.org roadmap
(http://tools.openoffice.org/releases) this issue was retargeted to
OOo Later." 

WORKAROUND: You should change the length of the field by yourown. OPen
the table in the datasource view and choos edit from the context menu.
Then change the length of the field to 254. Then save the table.
Comment 7 marc.neumann 2003-10-16 11:27:14 UTC 
.
Comment 8 hans_werner67 2004-02-02 12:54:58 UTC 
change subcomponent to 'none'
Comment 9 tom 2004-10-04 11:03:15 UTC 
TV: Duplicate to i16268. the good News is that the other bug has been fixed :).
It'll be in de master SRC680:m57.
Comment 10 tom 2004-10-04 11:03:40 UTC 
TV: Closing now.