Re: FN-FORUM: Anyone up for a little number puzzle?

date posted 18th January 2008 16:28

On Fri, 2008-01-18 at 12:59 +0000, Sam M - www.wiredeyes.com wrote:
> Hi Guys,
>=20
> I have a small issue, I have third party piece of software that stores da=
ta in mySQL. It has an invoice table and an invoice_items table
>=20
> The tables are linked together using the invoice id field but the origina=
l programmer has encoded the invoice id from the invoice table and saved th=
e encoded version in the invoice items table. The whole php application has=
been zend encoded so I can't check the code for the answer.
>=20
> What I'm trying to do is simply create a report using the data. But I can=
't match them up unless I can understand the encoding method.
>=20
> What I have at the moment is this when comparing the invoice id values wi=
th the encoded values=20
>=20
> 1 =3D %A4
> 2 =3D %A7
> 3 =3D %A6
> 4 =3D %A1
>=20
> However
>=20
> 10 =3D %A4%98
> 11 =3D %A4%99 NOT %A4%A4 as expected
> 12 =3D %A4%9A
>=20
> And=20
>=20
> 1024 =3D %A4%98%C4%C0 (Again not consistent)
>=20

What are the datatypes here? Is the '%A4%98' a string of some kind in
the database? What are the values for 5 .. 9? Are you sure the values
for 1..4 are mapped correctly: it's funny how the values for 10..12 go
up nicely but 1..4 don't.

Graham


> Can anyone work out what is going on?
>=20
> Cheers
>=20
> Regards=20
> Sam Morgan=20
> --=20
> WiredEyes Media / ServWise Advanced Hosting
>=20
> tel (Uk): +44 (0)20 7100 2178
> tel (Italy): +39 070 773 6543
> web : www.wiredeyes.com / www.servwise.com
> umop ap!sdn w,! aw dlaH
> --=20
> =E2=98=85=E2=98=85 Hosting from 63p per month using coupon : HALFPRICE
> =E2=98=85=E2=98=85 Domain Names from =C2=A33.89/y & 128bit SSL Certificat=
es only =C2=A38.00/y
>=20
>=20
>=20
>=20
>=20