Wait.. The "SQL Grammar" section looks like it has the info I need to make
sense of that.

 

http://docs.openlinksw.com/virtuoso/GRAMMAR.html

 

data_type has its lexical (I think) definitions listed.

 

If this is using flex/bison, I might just wonder into the source to help
learn virtuoso sql.

 

Matthew

 

 

From: Matthew Tedder [mailto:[email protected]] 
Sent: Friday, August 13, 2010 3:34 PM
To: [email protected]
Subject: [Virtuoso-users] What would be a SQL TEXT data type?

 

VARCHAR() seems limited at about 4K bytes.  I have study titles that go a
little over 700 characters long.  (Yes.  People who give studies 700+
character titles should be shot.  But we can't do that to them, in a civil
society.)

 

The page http://docs.openlinksw.com/virtuoso/sqlrefDATATYPES.html is not
clear what it's listing.  Trying to create a BLOB type, for example, gives an
error.  There appears to be virtually no descriptions.

 

 

Matthew C. Tedder

Software Engineer
Clinical and Translational Research Informatics Program (CTRIP)
University of Florida
1329 SW 16th St. RM 5026
Gainesville, FL 32608
352.265.0111 Ext. 86107 (desk)

509-432-5520 (cell)
UF Campus Mail: Box 100147/ICHP
USPS Mail: PO Box 100177, Gainesville, FL 32610

 

Reply via email to