Re: Support for varchar(max)
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 : > 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 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 >>> >>> >>> >
Re: Support for varchar(max)
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 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
Re: Support for varchar(max)
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 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 > >
Support for varchar(max)
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