summaryrefslogtreecommitdiff
path: root/libmysql
diff options
context:
space:
mode:
authormonty@mysql.com <>2004-10-20 16:24:28 +0300
committermonty@mysql.com <>2004-10-20 16:24:28 +0300
commite1218474b87e1c28f080207558966fac6f4eb292 (patch)
treef3f6e81dac72352598beb9c21f116d2ef7f9c3ef /libmysql
parentf9cd4a60e466a211024e5efb6840b79a3066f3c8 (diff)
parentb32ffec8fdc9d05377e69c8b1abb92d562670324 (diff)
downloadmariadb-git-e1218474b87e1c28f080207558966fac6f4eb292.tar.gz
Merge with 4.0
Diffstat (limited to 'libmysql')
-rw-r--r--libmysql/libmysql.c34
1 files changed, 34 insertions, 0 deletions
diff --git a/libmysql/libmysql.c b/libmysql/libmysql.c
index deb09c856ec..fb405a7b868 100644
--- a/libmysql/libmysql.c
+++ b/libmysql/libmysql.c
@@ -1544,6 +1544,40 @@ void my_net_local_init(NET *net)
}
/*
+ This function is used to create HEX string that you
+ can use in a SQL statement in of the either ways:
+ INSERT INTO blob_column VALUES (0xAABBCC); (any MySQL version)
+ INSERT INTO blob_column VALUES (X'AABBCC'); (4.1 and higher)
+
+ The string in "from" is encoded to a HEX string.
+ 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.
+ Each character needs two bytes, and you need room for the terminating
+ null byte. 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 does not contain any leading 0x or a leading X' and
+ trailing '. The caller must supply whichever of those is desired.
+*/
+
+ulong mysql_hex_string(char *to, const char *from, ulong length)
+{
+ char *to0= to;
+ const char *end;
+
+ for (end= from + length; from < end; from++)
+ {
+ *to++= _dig_vec[((unsigned char) *from) >> 4];
+ *to++= _dig_vec[((unsigned char) *from) & 0x0F];
+ }
+ *to= '\0';
+ return (ulong) (to-to0);
+}
+
+/*
Add escape characters to a string (blob?) to make it suitable for a insert
to should at least have place for length*2+1 chars
Returns the length of the to string