On Aug 13, 2010, at 03:34 PM, Matthew Tedder wrote: > 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.
I'm not sure why your 700 char titles won't fit into a VARCHAR(4000), unless they're Unicode chars, in which case I think you'd want to use an NVARCHAR(). That said, I think the data type you're looking for is LONG VARCHAR(). See <http://docs.openlinksw.com/virtuoso/coredbengine.html#DTLONG> for details of this, and other, data types. Be seeing you, Ted -- A: Yes. http://www.guckes.net/faq/attribution.html | Q: Are you sure? | | A: Because it reverses the logical flow of conversation. | | | Q: Why is top posting frowned upon? Ted Thibodeau, Jr. // voice +1-781-273-0900 x32 Evangelism & Support // mailto:[email protected] // http://twitter.com/TallTed OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 http://www.openlinksw.com/weblogs/uda/ OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/ http://www.openlinksw.com/blog/~kidehen/ Universal Data Access and Virtual Database Technology Providers
