how to save image to MySQL ?

2002-02-05 Thread yue cheng 

hi,forks,
Now I try to save image to MySQL, I create a table
with longblob field, i try two ways as follows but
both did not work 

1. use appendchunk, i succeed in saving image to MS
SQL with this funtion. but i can't save image to MySQL
with it.

2. using Load_File insert a bmp file (size is 102k)
into database and use select into outfile to retrieve
it, but the outfile size turned into 1k rather than
102k.

Can anybody give me  a hand? thank very much

amy

 

_
Do You Yahoo!? 
µ½ÊÀ½ç±­Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±­ÃÅƱÀÖÒ»ÀÖ¡£
http://cn.worldcup.yahoo.com/

-
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

how to save image to mySQL

2002-02-05 Thread yue cheng 

hi forks,

I try to save image to MySQL and I create table with
longblob field. but i failed with following two ways:

1. use appendchunk and getchunk which are succeful in
MS SQL but failed in MySQL

2 insert a bmp file(size is 54k) into table with
load_file and get data from table using select into
outfile, but the size of outfile turned into 1k. 

Can anybody give me a hand? Thanks in advance

amy 

_
Do You Yahoo!? 
µ½ÊÀ½ç±­Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±­ÃÅƱÀÖÒ»ÀÖ¡£
http://cn.worldcup.yahoo.com/

-
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