RE: Re: New Rio Client - Stage 1 Complete

[Frost Neil]

Access still has a query field length limit of 255 characters though.

-----Original Message-----
From: Graham Howe [mailto:<a
href="/group/ukha_xpl/post?postID=Of03EsVX_Fw5oY0LRZOEsiv6davRXt1AIsfU6CtxCYbf4o7sKPjb4cQj1Xe6pCWXU244xUUbXuAUuuKtJyvG">graham@s...</a>]
Sent: 08 February 2004 16:39
To: <a
href="/group/ukha_xpl/post?postID=sVSupJkdl4YqUgGQ-I_GOkuqk49Pn7kPJ5BY3nJnJd6DA45_AMTMnLAjqohbTe_wf5CPzqnWdmgGJGwJTSp2K2r0lQ">ukha_xpl@xxxxxxx</a>
Subject: RE: [ukha_xpl] Re: New Rio Client - Stage 1 Complete

SQL server varchar limit is 8000 if you have version 7 or greater, prior to
that it was 255. However there is also a total 8000 limit on the table, so
you could not have one field with 6000 characters and another with 3000 for
example. Of course there is always the option of the text datatype, but
there are some limitations as to which commands will work with that.


xPL Links: <a href="http://www.xplproject.org.uk";>http://www.xplproject.org.uk</a>
<a href="http://www.xplhal.com";>http://www.xplhal.com</a>
<a href="http://www.xpl.myby.co.uk";>http://www.xpl.myby.co.uk</a>
To Post a Message: <a
href="/group/ukha_xpl/post?postID=sVSupJkdl4YqUgGQ-I_GOkuqk49Pn7kPJ5BY3nJnJd6DA45_AMTMnLAjqohbTe_wf5CPzqnWdmgGJGwJTSp2K2r0lQ">ukha_xpl@xxxxxxx</a>
To
Subscribe: <a
href="/group/ukha_xpl/post?postID=Nshtp2kQMDsAux_BbXOet-5KLKh6TI4Zrisa8rAxczLsYjXKMUmYkLH6ShKev7IhrpCxIRdDU_sCDIfcdQzaEvfTSb3vgp7AD1nG">ukha_xpl-subscribe@xxxxxxx</a>
To Unsubscribe: <a
href="/group/ukha_xpl/post?postID=BRwMloWMSrx8IlSQaUm3vr1DGW-ryu8x0AH8vk_OolqSfidshjAGhZsRdTWoGBHYHJtOcqUK3uubmX8AhF0HvxgTBT9bo_kqciViWXH9eA">ukha_xpl-unsubscribe@xxxxxxx</a>