encode and decode

[Ricky]

I want to use encode and decode in a varchar field size 100.
This would just hold last and first names.
Would this give me any porblems?

thanks for any help!
Ricky

[steve]

"Ricky" wrote:

I want to use encode and decode in a varchar field size 100.
This would just hold last and first names.
Would this give me any porblems?

thanks for any help!
Ricky

I assume you mean you want to stuff both first and last names into a
single field.

No problem. Do it like this:
assume
$firstname="ricky";
$lastname="martin";

Then save it as
$crunched = serialize( array($firstname, $lastname));
save $crunced into db.

Once you read it back, to unserialize, and parse the element of the
resulting array.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-encode...ict134657.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=450213

[Ricky]

I read that it is recommended using a blob field when using encode and
decode functions ?

"Ricky" <rf*********@earthlink.net> wrote in message
news:to*****************@newsread1.news.pas.earthl ink.net...

I want to use encode and decode in a varchar field size 100.
This would just hold last and first names.
Would this give me any porblems?

thanks for any help!
Ricky