SQL query string length limit

Print Thread

SQL query string length limit #31144 13 Mar 17 03:51 PM
Joined: Nov 2006 Posts: 2,223 Northwest Arkansas S Stephen Funkhouser OP Member
OP Stephen Funkhouser Member S Joined: Nov 2006 Posts: 2,223 Northwest Arkansas	What is the effect query string length limit? Stephen Funkhouser Diversified Data Solutions

Re: SQL query string length limit #31145 13 Mar 17 03:59 PM
Joined: Jun 2001 Posts: 11,794 Woodland Hills, CA J Jack McGregor Member
Jack McGregor Member J Joined: Jun 2001 Posts: 11,794 Woodland Hills, CA	I think there is effectively no limit, at least in the libashmysql connector. (If there is a limit, it would be in the mysql connector or database.) But it must be null terminated. (That would be automatic except for fixed length strings where the physical mapped length was <= its logical length.)

Re: SQL query string length limit #31146 13 Mar 17 04:08 PM
Joined: Nov 2006 Posts: 2,223 Northwest Arkansas S Stephen Funkhouser OP Member
OP Stephen Funkhouser Member S Joined: Nov 2006 Posts: 2,223 Northwest Arkansas	OK, thanks. Stephen Funkhouser Diversified Data Solutions