dear kayamboo,
i've tried it, but seems there still something strange with this matter, so
i decided to create one table with myisam table type (default table type),
and i try to input data in this table. but when i check this up (do query) i
have null value in mediumblob field (pic).
this is the captured process...
Logging to file 'c:\mysql\problem.txt'
mysql> create table tblob
-> (
-> title varchar(100) null,
-> pic mediumblob null
-> );
Query OK, 0 rows affected (0.06 sec)
mysql> desc tblob;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| title | varchar(100) | YES | | NULL | |
| pic | mediumblob | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> insert into tblob
-> values('Test', load_file('c:/mysql/betasw.gif'));
Query OK, 1 row affected (0.00 sec)
mysql> select * from tblob;
+-------+------+
| title | pic |
+-------+------+
| Test | NULL |
+-------+------+
1 row in set (0.00 sec)
mysql> \t
TIA,
Ivan Paul
sql, query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
