Re: images with mysql

2003-03-20 Thread Lai Liu-yuan
don't have to retrieve > pictures from the database so it might be quicker.. > > > > B. > > > At 18:34 20-03-2003 +, Lai Liu-yuan wrote: > >I am now having a database storing images of chinese characters for > >research purpose. I wrote a program to st

Re: images with mysql

2003-03-20 Thread Lai Liu-yuan
I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql> describe poor; +++--+-+-+---+ | Field | Type

Re: This query shouldn't be wrong, but mysql says it is???

2003-03-19 Thread Lai Liu-yuan
I reread the mysql manual again, and found the little piece I've missed : version 4!! That's the problem. Thanks for your reply. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

Re: Is mysql_real_escape_string for blob storage?

2003-03-11 Thread Lai Liu-yuan
Thanks for your reply. But, what then is the role of mysql_real_query? In document, it says "You must use mqsql_real_query for queries that contain binary data"? - Before posting, please check: http://www.mysql.com/manual.php

Is mysql_real_escape_string for blob storage?

2003-03-11 Thread Lai Liu-yuan
Hi, everyone. I use blob to store image data in mysql. I use mysql_real_query to store it, but did not use mysql_real_escape_string to process it before hand. Then I saw in the document that this is needed. But I am testing the data stored by reading them out to do some processing, there seems

what's wrong with this query?

2003-03-10 Thread Lai Liu-yuan
Please help me with the following c code: sprintf(update, "update chrc set center='"); len = 24; memcpy(update+len, center, 128); len += 128; sprintf(update+len, "', var='"); len += 8; m