(mysql.info.gz) mysql_hex_string

Info Catalog

(mysql.info.gz) mysql_get_server_version

(mysql.info.gz) C API functions

(mysql.info.gz) mysql_info

 
 22.2.3.30 `mysql_hex_string()'
 ..............................
 
 `unsigned long mysql_hex_string(char *to, const char *from, unsigned
 long length)'
 
 Description
 ...........
 
 This function is used to create a legal SQL string that you can use in a
 SQL statement.  String syntax.
 
 The string in `from' is encoded to hexadecimal format, with each
 character encoded as two hexadecimal digits.  The result is placed in
 `to' and a terminating null byte is appended.
 
 The string pointed to by `from' must be `length' bytes long.  You must
 allocate the `to' buffer to be at least `length*2+1' bytes long.  When
 `mysql_hex_string()' returns, the contents of `to' will be a
 null-terminated string.  The return value is the length of the encoded
 string, not including the terminating null character.
 
 The return value can be placed into an SQL statement using either
 `0xVALUE' or `X'VALUE'' format.  However, the return value does not
 include the `0x' or `X'...''. The caller must supply whichever of those
 is desired.
 
 `mysql_hex_string()' was added in MySQL 4.0.23 and 4.1.8.
 
 Example
 .......
 
      char query[1000],*end;
 
      end = strmov(query,"INSERT INTO test_table values(");
      end = strmov(end,"0x");
      end += mysql_hex_string(end,"What's this",11);
      end = strmov(end,",0x");
      end += mysql_hex_string(end,"binary data: \0\r\n",16);
      *end++ = ')';
 
      if (mysql_real_query(&mysql,query,(unsigned int) (end - query)))
      {
         fprintf(stderr, "Failed to insert row, Error: %s\n",
                 mysql_error(&mysql));
      }
 
 The `strmov()' function used in the example is included in the
 `mysqlclient' library and works like `strcpy()' but returns a pointer
 to the terminating null of the first parameter.
 
 Return Values
 .............
 
 The length of the value placed into `to', not including the terminating
 null character.
 
 Errors
 ......
 
 None.
 

Info Catalog

(mysql.info.gz) mysql_get_server_version

(mysql.info.gz) C API functions

(mysql.info.gz) mysql_info