I tried using that but as you referred to, many sql environments do not like, and to be redundant UV Sql does not like the MAX reference
Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] ----------------------------------------------------- Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat. t. roosevelt ---------------------------------------------------------------- P Before printing please think about your environmental responsibility -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Sunday, July 20, 2008 7:28 PM To: [email protected] Subject: Re: [U2] [UV] UVSql UniVerse/SQL is quite limited in its range of data types. Use VARCHAR(65535), which I believe is the largest size you can have in DDL, but it seems not to be enforced as an upper limit in most cases. > ----- Original Message ----- > From: "Barry Rogen" <[EMAIL PROTECTED]> > To: [email protected] > Subject: [U2] [UV] UVSql > Date: Fri, 18 Jul 2008 16:08:35 -0400 > > > Hello all, > > I have a challenge before me and would appreciate some helpful > ideas. > > > Challenge: I need to build a sql table where one column could > (quite) possibly get quite large. I have tried data type TEXT and UVSql > did not like that. I tried a data type of VARCHAR(MAX) and UVSql did > not like that . Those are the only two (one admittedly obsolete) data > types I know that would allow for the handling of a string of > considerable size. > I was really quite surprised that VARCHAR(MAX) was rejected by UV. > > Suggestions, ideas. > > > Thank you very much !! > > Barry Rogen > PNY Technologies, Inc. > Senior Programmer/Analyst > (973) 515 - 9700 ext 5327 > [EMAIL PROTECTED] > > ----------------------------------------------------- > Far better it is to dare mighty things, to win > glorious triumphs even though checkered by > failure, than to rank with those poor spirits who > neither enjoy nor suffer much because they live > in the gray twilight that knows neither victory > nor defeat. t. roosevelt > ---------------------------------------------------------------- > > P Before printing please think about your environmental responsibility > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
