Re: Maximum number of TEXT columns ?

I wrote: |> |> Ian Ilsley writes: |> |> |> |> --- |> |> |> |> Does anyone know if there is a limit with the number of text columns one |> |> |> |> can have in a single table. ? |> |> There is no limit on the number of columns of ANY type, but the max row |> length is 32K, which effectively limits the number of columns based on the |> length of the columns (e.g. you could have 1 32K column, or 32 1K columns, |> etc.). Sorry, I forgot to mention that for blob data types (TEXT or BYTE), 56 bytes of row space is used for each column. So assuming the absurd case of a row with nothing but TEXT columns, you could have 32K/56 columns in the table. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney