Hello everybody,

I'm searching a way of storing different data types into a mysql database, for example in image (.jpeg), using a blob type for the concerned colomn... but it doesn't work at all ! Is there a way of doing that, without only storing the path to the specified file ?

Thanks ! Gluon

In what way doesn't it work, and how are you trying?

cheers

Jamie...

Hi,

Here is the output lines :
mysql> SELECT * FROM files;
Empty set (0.00 sec)

mysql> DESCRIBE files;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| data | longblob | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> LOAD DATA LOCAL INFILE "login.pcx" INTO TABLE files;
Query OK, 158 rows affected (0.02 sec)
Records: 158 Deleted: 0 Skipped: 0 Warnings: 60

Ideally, I'd like to have 1 single affected row, instead of 158... I guess that some characters of the file are interpreted as end_of_line's, aren't they ?

Thanks in advance !
Gluon