From: Shigeya Suzuki
Date: July 16 2006 1:06pm
Subject: fixed length char handling/declaration by SSQL
List-Archive: http://lists.mysql.com/plusplus/5825
Message-Id: <44BA39DF.9060706@wide.ad.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

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.