Re: mysql_real_query and escaping a semicolon

[Paul DuBois]

>Paul DuBois wrote:
>
>>  At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
>>  >Well, the function is called like this:
>>  >
>>  >mysql_real_query( mysql_connection, query_string, strlen( query_string ));
>>  >
>>  >Wouldn't that pass the correct length?
>>
>>  Not necessarily.
>
>Uhm... why not?  Wouldn't strlen return the length of the string, ie, the
>number of characters, and wouldn't that be the length in bytes?
>
>--Anna

Because mysql_real_query() allows the possibility that the query
string contains binary data (including null bytes), in which case
strlen() won't necessarily be correct.

*IF* the query string doesn't have anything like that in it,
then your call should work.  I just find it hard to believe that
a semicolon would cause any problem.