Hi,
I'm new to mysql++ and trying to figure out how to use this.
One of the code snipped I need to write is store some fixed length
binary data (say, char(16)) and want to handle it efficiently or want to
write it in C+ as easy as possible. In other words, I'd like to store
IPv6 address as column and want to handle it via a class. (I plan to
store it as varchar but actually, whether this is efficient in MySQL
point of view is another question - I have not used MySQL very seriously
till now..)
Say, I want to write, for example,
sql_create_3(AddressToAS,
3, 0,
unsigned int, ata_id,
SOME_CLASS_NAME ata_addr,
unsigned int, ata_as);
and, want to use storein(some_vector)...
I understand that it is possible to fetch binary data using
'fetch_lengths' function (according to ML), but since I love power of
SSQLS, I prefer using it if possible. Or, prefer to write or modify some
template to achieve this. I tried to use string but string seems to be
not working well.
I checked mailing list but there are no mention about fixed length
binary as I check. I read reference but no mention about such. I will
read code, but I want to know whether it is possible to write it easily
or not...
Any information appreciated.
shigeya
PS. I didn't know about mysql++ - this library is really good. Actually,
I've tried to write DB independent C++ SQL DB libraries for three times
in last 12 years and always not satisfied with result.. Fortunately I
currently only need to use MySQL for my personal research purpose, so it
perfectly fit to my needs. thanks.
