Max no. of columns in Firebird is 255

Not true.

I don't think you are right, because i have tested Fireird 2.0.0.12748 DB
by Data Provider, and i could only insert max of 255 columns after
that which it says "Unsuccessful MetaData update. Too many versions".

manish


On 4/2/07, Helen Borrie <[EMAIL PROTECTED]> wrote:

At 03:29 PM 2/04/2007, you wrote:
>Max no. of columns in Firebird is 255

Not true.

>, and max row size is 64K,

Yes

>so no. of columns will depend upon the column type you are using

Yes.

There is also a limit of 64 K bytes for the length of a single SQL
statement.


>On 4/2/07, Gary Saunders
><<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]> wrote:
>Is there a limit to the number of columns I can access or create through
the
>.net provider.  I have a command that attempts to create over 250 columns
in
>a new table.  I can only get 20 some columns if the column type is
varchar
>and 256 if they are integer.

What error[s] do you get if you don't succeed?  It would certainly
help to see where you are encountering this apparent limitation.

Helen


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to