From: Warren Young
Date: August 9 2007 12:01pm
Subject: Re: How to initialize mysqlpp::sql_tinyblob?
List-Archive: http://lists.mysql.com/plusplus/6901
Message-Id: <46BB0228.5060503@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Graham Reitz wrote:
> How would you initialize password in the following SSQLS?
> 
> sql_create_2(clients, 1, 2,
>                      unsigned int, client_id,
>             mysqlpp::sql_tinyblob, password)
> 
> clients client;
> client.client_id = 1;
> client.password = ????;

I imagine you're using a BLOB type because you're keeping the password 
in some sort of binary representation, so a straight assignment won't 
work.  Perhaps you're using a hashing scheme and want to use the raw 
binary form instead of a hexadecimal text representation.

If reconsidering the choice to use a binary representation isn't an 
option, you can get by with this:

	ColData cd(ptr_to_data, bytes_in_data_block);
	client.password = cd;

All of the BLOB types as of v2.3 are typedefs for ColData.