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/
