There is no TEXT type yet and it would be good to add the type. Also there are two issues to be improved for VARCHAR: (A) The current varchar is restricted to be within a storage block, i.e. 2MB by default configuration. (B) For varchar with relative large size (e.g. varchar(8192)), a storage block will just be partially filled then mark full -- due to some reservation check during bulk insert -- thus wasting storage space.
2017-12-04 17:20 GMT-06:00 Dylan Bacon <dba...@wisc.edu>: > Varchar(MAX)/TEXT is a construct that lets you put in an arbitrary amount > of text into the string with no defined upper limit unlike varchar(#) where > # is the character limit. It's a small technical limitation to a project > I'm working on if we don't have it but it's easy enough to work around, was > mostly curious if we have that support. I'm shoving email bodies into QS > and having arbitrary text would make that more powerful. > > > > On 12/4/17 5:17 PM, Robert Claus wrote: > >> I've used varchar successfully in Quickstep, but I don't know what >> functions are supported. Is there specific functionality you're looking >> for? >> >> Ex. "CREATE TABLE Child (a int, b int, c varchar(20));" >> >> -Robert >> >> On Mon, Dec 4, 2017 at 5:01 PM, Dylan Bacon <dba...@wisc.edu> wrote: >> >> Hello, >>> >>> Does Quickstep currently have support for arbitrary-length BLOB format >>> varchars? Think TEXT or varchar(MAX) from SQL Server. >>> >>> -- >>> Regards, >>> >>> Dylan Bacon >>> University of Wisconsin - Madison >>> Department of Computer Sciences >>> dba...@wisc.edu >>> >>> >>> >
