[PHP-DB] storing PDF in a database

2002-03-24 Thread Alain DESEINE 

Hello,

For many different reasons, like security ans soùme other one, i need to 
store PDF files in a database.

- Does anybody have already do this ?
- What kind of field type should i use (image filed type ???) ?

I'm currently using an ASE 12 (64 bits) SYBASE server on a HP-UX 11.00 
(64 bits) box.

The application server is a linux server with apache and PHP.

Any feedback about doing somethin like this will be valuable ...

Many thanks for responses.

Best regards,

Alain DESEINE.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] storing PDF in a database

2002-03-24 Thread Jason Cox 

You'd want to use a BLOB field to store it.  It would be stored as raw data
in the db.  For an example, go find a tutorial on how to store images in the
database.  It would work the same way.

Jason Cox

- Original Message -
From: Alain DESEINE [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 24, 2002 2:32 AM
Subject: [PHP-DB] storing PDF in a database


 Hello,

 For many different reasons, like security ans soùme other one, i need to
 store PDF files in a database.

 - Does anybody have already do this ?
 - What kind of field type should i use (image filed type ???) ?

 I'm currently using an ASE 12 (64 bits) SYBASE server on a HP-UX 11.00
 (64 bits) box.

 The application server is a linux server with apache and PHP.

 Any feedback about doing somethin like this will be valuable ...

 Many thanks for responses.

 Best regards,

 Alain DESEINE.


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] storing PDF in a database

2002-03-24 Thread Kevin Won 

I have the same need for all sorts of doc types w/ m$ sql server. The wrox 
'professional sql server programming' talks about this issue of storing file type data 
in a table row briefly, leaving me disheartned. basically, the summation of the issue 
is it's a really bad idea performance wise--like it can bring the server down to its 
knees, because essentially (as I understand it) there is a 3 part method of 
abstraction where sql server actually puts your data into its own discreet file which 
is accessed via the sql server on a per-query basis. 

ouch.

This sorta contradicts the fuzzy marketing-type hype I've read elsewhere that suggests 
using the IMAGE data type to store .doc or .xls data with a full-text index to make it 
searchable.

I don't know if the sybase system has a comprable data type, but that would be the 
solution on the m$ side in theory, though in practice, the wrox book steers you away 
from putting documents in the rdbms.

I hope I'm wrong and someone else is doing this and can post a workable solution.

kevin

 Alain DESEINE [EMAIL PROTECTED] 03/24/02 05:36 AM 
Hello,

For many different reasons, like security ans soùme other one, i need to 
store PDF files in a database.

- Does anybody have already do this ?
- What kind of field type should i use (image filed type ???) ?

I'm currently using an ASE 12 (64 bits) SYBASE server on a HP-UX 11.00 
(64 bits) box.

The application server is a linux server with apache and PHP.

Any feedback about doing somethin like this will be valuable ...

Many thanks for responses.

Best regards,

Alain DESEINE.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php