Re: Support for varchar(max)

2017-12-04 Thread Jianqiao
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 bloc

Re: Support for varchar(max)

2017-12-04 Thread 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,

Re: Support for varchar(max)

2017-12-04 Thread Robert Claus
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 curren

Support for varchar(max)

2017-12-04 Thread Dylan Bacon
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