If you mean a file as in an image or other binary data, you need to use a BLOB field.
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Joe Baptista" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, 14 June, 2003 19:57 Subject: howto store files in mysql I need to store a file as mysql record. I assume I use the text variable but have no idea how to read the file into the mysql record. Please note I am not reading a file to a table - so not the LOAD DATA INFILE function but a means of storeing the contents of a file as a record. anyone know how to do that or the url of the manuel which explains it. thanks joe baptista Joe Baptista - only at www.baptista.god "The Americans, they always depend on a method what I call ... stupid, silly. All I ask is check yourself. Do not in fact repeat their lies." ... Muhammed Saeed al-Sahaf former Iraqi Information Minister -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]