Again Thanks Warren. I agree with you totally on
creating different tables. However the architect here
is well....stupid.
Hence I'm forced to use Chris Freys packarray a browse
and hopefully understand what is going.
Cheers,
Garyc
--- Warren Young <mysqlpp@stripped> wrote:
> gary clark wrote:
> >
> > i.e L=76 , L being the raw data and 76 being the
> > equivalent?
>
> I see...you are trying to pack smaller data items
> into a string. Okay,
> understand, this is generally bad style. If you
> need a 1-byte column,
> you should usually create a 1-byte column. If you
> have a variable
> number of values, you just need another table, keyed
> to the first.
>
> Just as an example, consider a business that has a
> Customer table, but
> they decide that customers need multiple addresses.
> Instead of just
> adding more address columns or trying to pack
> multiple addresses into
> the existing structure, they correctly create the
> CustomerAddress table,
> keyed on the ID column from the Customer table.
> This lets them have as
> many addresses as they need, without trickery.
>
> If you can't normalize the data this way for some
> reason, give Chris
> Frey's packarray patch a look. It's in the mailing
> list archives. It's
> mainly waiting for a little user love before it can
> be included in the
> library.
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:
>
http://lists.mysql.com/plusplus?unsub=1
>
>
