diff options
author | monty@mysql.com <> | 2004-10-20 18:58:01 +0300 |
---|---|---|
committer | monty@mysql.com <> | 2004-10-20 18:58:01 +0300 |
commit | b686f98f50564d8562f3370f3b58d0fbb59c6da5 (patch) | |
tree | debb263a1715393b70af52ed938f800953c18d4e /libmysql | |
parent | a1bd5432c49140715db9f2dfa47b4c4d47db19fb (diff) | |
parent | 4e63fb9891918fdc459b3153965af372f22d40b6 (diff) | |
download | mariadb-git-b686f98f50564d8562f3370f3b58d0fbb59c6da5.tar.gz |
Merge bk-internal.mysql.com:/home/bk/mysql-4.1
into mysql.com:/home/my/mysql-4.1
Diffstat (limited to 'libmysql')
-rw-r--r-- | libmysql/libmysql.c | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/libmysql/libmysql.c b/libmysql/libmysql.c index 5dc5379e180..6a67697169a 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_upper[((unsigned char) *from) >> 4]; + *to++= _dig_vec_upper[((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 |