RE: [PHP-DB] Images/Picture!
| From: | Lars Wilhelmsen | Date: | Tue, 18 Jul 2000 08:35:19 +0000 |
| Subject: | RE: [PHP-DB] Images/Picture! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1233@lists.php.net to get a copy of this message | ||
Hi again,
No - there shouldn't be any changes to the pictures (I've stored .zip files
this way).
-larsw-
--
Lars Wilhelmsen <lw@ez.no>, developer @ eZ systems <www.ez.no>
-----Original Message-----
From: salmanas@nurulfikri.com [mailto:salmanas@nurulfikri.com]On Behalf
Of Salman AS
Sent: 18. juli 2000 10:36
To: Lars Wilhelmsen
Subject: Re: [PHP-DB] Images/Picture!
Lars Wilhelmsen wrote:
> Hi!
>
> You really don't want to store binary files (pictures) in your DB.
> It's slow to store/retrieve them.
I am using PostgreSQL, and new to MySQL. So, I wonder that there is a
datatype in MySQL to store picture.
> But (If you use MySQL) You could:
>
> Make a columns with the type of LONGBLOB,
> read in a file into a variable, (remember addslashes() )
> and the store it into the db with a simple "INSERT INTO " statement.
Is there changes to the picture if I use this way to save the picture in
DB?
-------------------
Salman AS (SaS)
salmanas@telkom.net
-------------------