https://bugs.freedesktop.org/show_bug.cgi?id=51203
--- Comment #11 from Owen Genat <[email protected]> --- (In reply to comment #6) > I would just like a field type of 'Hyperlink' which works in the > same fashion as MS Access. This is just for information. The Microsoft Access Hyperlink data type is based on the Microsoft Jet Memo data type i.e., it is a proprietary / non-standard modification. Jet is the database engine used in Access. SQL Server has no equivalent of this data type. HSQLDB (v1.8 or v2.3) and Firebird do not have a Hyperlink data type either. The reason why these databases do not have this type is likely because they rely on an SQL specification (e.g., ISO/IEC 9075-2:2008) to determine valid data types. Examining the Final Committee Draft (FCD) for the 2011 version of the SQL specification, indicates this updated version still does not define a Hyperlink data type. Similarly, ODF v1.2, Part 1, ยง19.42 (p. 344) defines the db:data-type attribute as being defined by ISO/IEC 9075-2:2008 and gives this example: > The values of the db:data-type attribute are bit, boolean, tinyint, smallint, > integer, bigint, float, real, double, numeric, decimal, char, varchar, > longvarchar, date, time, timestmp, binary, varbinary, longvarbinary, sqlnull, > other, object, distinct, struct, array, blob, clob or ref. While I can see the value of having a Hyperlink data type, it would appear to depend on one of these options: 1. Changing ISO/IEC 9075-2 (unlikely). 2. Changing ODF to support a non-standard data type (also unlikely). 3. Changing ODF to include a further data attribute indicating special treatment of a VARCHAR data type (possible, but requiring an OASIS issue to be raised). 4. Some sort of hard-coded implementation in Base for special treatment of a VARCHAR data type (possible, but maybe undesirable). Option (3) would seem most likely IMO. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
