rt my program, and before that making a test to check,
which time needs to delete 1 GB of blobs.
I installed MySQLDb from the exe (Py2.6, from stackoverflow version), set
all parameters, etc.
import MySQLdb
conn = MySQLdb.connect (host = "localhost",
user = "root",
passwd
Hi!
I want to test my program that coded into PGSQL, and PySQLite. With these
DBs I have problem on many blob deletion (2 hours) and compact/vacuum (1
hours)...
So I'm trying to port my program, and before that making a test to check,
which time needs to delete 1 GB of blobs.
I inst
We have had some cases where we wanted to recover data using the binlogs
from some days ago. The database has a lot of binary objects (blobs).
The normal way to recover are to restore database files from a
consistant point, and then use mysqlbinlog to spool from that point till
where we want to
Hello,
I need some advice for setting up a mysql database (debian etch) to
store many blobs (about 1 GB) . I run a HP DL 360 (?), 1 GB RAM,
RAID 5, 10K disks, 30 GB and the standard installation of mysql
coming with debian etch (5.0.32, readline 5.2)
I need only one database (innodb) with 1
Can anyone point me in the direction of some examples of using the
libmysqclient API for reading/writing blobs ?
I'm currently reading the data from some dynamic SQL using
mysql_stmt_bind_result & mysql_stmt_fetch - and want to add the BLOB
datatypes
TIA
--
Mike Aubury
12:46 PM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: MySQL Error for Blobs
>
> I got an error while entering an BMP image of 1.7MB size in a
> mediumblob field through MS Access 2003 with MyODBC 3.51.12
> on Windows XP SP2 also with MySQL Query Browser
> and Navi
max_allowed_packet is the maximum size of a single SQL statement.
It's a setting on the server, as well as for the mysql command line
interface.
See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
I think 1 MB is the default; the maximum setting for MySQL 5 is 1 GB.
You can adjust t
I got an error while entering an BMP image of 1.7MB size in a
mediumblob field through MS Access 2003 with MyODBC 3.51.12
on Windows XP SP2 also with MySQL Query Browser
and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger
than Max_allowed_packet bytes'. What this means?. Acces
At 20:15 -0700 11/2/05, Steve Johnson wrote:
The documentation notes that BLOBS must escape certain characters ( NULL, etc
.
What documentation are you referring to?
Also, NULL is not a character. Do you mean NUL (byte with value of 00)?
I suspect the escaping that you're referring
The documentation notes that BLOBS must escape certain characters ( NULL,
etc ). Since a blob is not of any character set, how do I know how to
prepare a blob for insert? ( which character set / character size to use to
test for characters that need to be escaped?
Thanks,
Steve
--
MySQL
ld be excluded from the
restrictions, shouldn't they?
Yet, my tables is made of 104 varchar(255) fields (I know it's bad, but
unfortunately
it's a structure I can't change), a dozen blobs and 8 other fields (date
and int),
so it seems that Innodb _is_ including varchar() field
Nico Sabbi wrote:
Hi,
with mysql 4.1[234], importing a dump of Innodb tables containing at
least a blob field
I invariably get_
ERROR 1030 (HY000) at line 21027: Got error 139 from storage engine
I read in the bugzilla that this problem is due to low memory
conditions, but
surely it's not m
Hi,
with mysql 4.1[234], importing a dump of Innodb tables containing at
least a blob field
I invariably get_
ERROR 1030 (HY000) at line 21027: Got error 139 from storage engine
I read in the bugzilla that this problem is due to low memory
conditions, but
surely it's not my case: the server h
Did you try:
select blob_field
from blob_table
order by length(blob_field) DESC limit 1
Regards,
Artem
> -Original Message-
> From: Roland Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 01, 2005 10:02 AM
> To: mysql@lists.mysql.com
> Subject: Find th
Hi,
since reading blobs is not a simple action (heavy), you must store the size of
every file in the table's structure.
if you write with php, somthing like that filesize($binFile) gives you the
column value for every insert
When done, a simple order by filesize gives you what you want b
Hi!
I've need to find the largest blobs in a table but I seem not to be able
to figure out what it is. Could anyone please help me with this?
Regards
Roland
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
My apologies for rushing in with a question that gave
little in the way of details.
I've straightend out the mess ;)
Just in case it's of any relevance, I've opted to
store the gifs in a file directory and use a varchar
field to make a link to the file / directory.
All is good.
Sorry again!
Stuart
At 9:56 -0700 9/4/04, Stuart Felenstein wrote:
This maybe OT but perhaps somone has a clue here.
I am storing gifs in a Blob, well tinyblob field.
I was under the assumption they could just be
pulled out and shown on a web page similar to running
any other query.
Apparently not, someone have a hint
This maybe OT but perhaps somone has a clue here.
I am storing gifs in a Blob, well tinyblob field.
I was under the assumption they could just be
pulled out and shown on a web page similar to running
any other query.
Apparently not, someone have a hint ?
Thanks
Stuart
--
MySQL General Mailing
by only including the BLOB
> data when it was actually needed for the output.
>
> Could his performance differences be because the BLOB objects are
> interspersed _between_ the "ROW" objects and is forcing his disks to
> seek more to get from row to row? Or, does anyone kn
t.
Could his performance differences be because the BLOB objects are
interspersed _between_ the "ROW" objects and is forcing his disks to seek
more to get from row to row? Or, does anyone know if his initial theory
(that the BLOBs were loaded even if not needed) is right?
humbly impressed
Here's one more quote, it is more relative to Alec's comment/concern
about access speed.
"It is unlikely that the 'field and offset are on different pages'
unless the record contains a large BLOB."
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
mns are packed using either Huffman or enum coding.
For details, see the source files /myisam/mi_statrec.c (for fixed
format), /myisam/mi_dynrec.c (for dynamic format), and
/myisam/mi_packrec.c (for packed format).
Note: Internally, MySQL uses a format much like the fixed format which
it uses for d
CTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 8:36 AM
To: emierzwa
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Where are BLOBs / TEXTs stored?
I am curious about this, too. However, I don't think that you answer the
original question.
Are BLOBs stored as separate f
[EMAIL PROTECTED] wrote on 17/06/2004 15:35:36:
>
> I am curious about this, too. However, I don't think that you answer the
> original question.
>
> Are BLOBs stored as separate files, one file per object? Are they
combined
> into a single large BLOB file? are they
I am curious about this, too. However, I don't think that you answer the
original question.
Are BLOBs stored as separate files, one file per object? Are they combined
into a single large BLOB file? are they aggregated into several medium
sized files? Answering "where are they stored o
other column types, for
which storage is allocated once per column when the table is opened.
Ed
-Original Message-
From: Luis R. Rodriguez [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 6:37 PM
To: [EMAIL PROTECTED]
Subject: Where are BLOBs / TEXTs stored?
[ Please CC me ]
Hi,
[ Please CC me ]
Hi,
http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
Page says:
---
"The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB
and TEXT column accounts for only five to nine bytes toward this size."
---
Question: So where are BLOBs and TEX
Hello, I tried dumping my innodb tables that contain blobs. No errors are returned
from mysqldump but I cannot restore the blob data. I have used the below mysqldump
statement.
mysqldump --opt --add-drop-table --force --single-transaction -uxxx -pxxx
--databases myDB >> bakupF
I have a database that stores information in Japanese characters stored in
a blob formatted fields. I am having trouble copying these fields from one
database to another.
I tried doing a mysqldump on the table and then copyng the Insert statement
generated but that failed; the inserted filed
Lou Olsten wrote:
I tried this and it DOES work with my PDFs. However, I didn't fully
understand how LOAD_FILE would handle all different kinds of binary data, so
I tried the same thing with a JPG. It ended up dropping over half of the
data. So although LOAD_FILE does work for my PDFs, how can I
Pachev" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 5:01 PM
Subject: Re: Saving PDF's as Blobs
> Lou Olsten wrote:
> > What SQL statement can I use to insert a PDF into a BLOB column? I
don&#x
Lou Olsten wrote:
What SQL statement can I use to insert a PDF into a BLOB column? I don't want a pointer to the file, I want the actual file stored as a BLOB.
If the file is on the server already -
insert into pdfs (content) values(load_file('/path/to/file.pdf'))
If the file is on the client,
What SQL statement can I use to insert a PDF into a BLOB column? I don't want a
pointer to the file, I want the actual file stored as a BLOB.
Thanks!
Lou
I had posted the following code in the plusplus mailing list but it was
suggested I post this question in this list instead.
I've been writing a test program using the MySQL C API to test the
reading and writing of BLOB data in and out of the database. The file I
read into the database is a sm
about what I do w/my pointers, and not to use string-handling
> functions on the blob data. I also use mysql_real_query(), which is where
> the error is returned. From what I can tell from the on-line documentation,
> this is the right way to handle blobs. I also tried:
>
> sp
double quotes, then when that didn't work, I went through a
very long process of trying long strings of decimal numbers, with varied
result, many of which didn't generate an error even. When I finally hit on
single quotes, it came together. I remember fighting for rather a long time
w/SQL
Angus,
On Sat, Dec 27, 2003 at 11:09:54AM -0500, Angus March wrote:
> > On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote:
> http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_query
> > > The quote I'm thinking of is:
> > > You must use mysql_real_query()
> On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote:
> > > Angus,
> > >
> > > On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> > > > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting
a
> > very
> > > > vague error: something about a problem "near '' on line
On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote:
> > Angus,
> >
> > On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> > > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a
> very
> > > vague error: something about a problem "near '' on line 1". I'm
> for
> Angus,
>
> On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a
very
> > vague error: something about a problem "near '' on line 1". I'm
forumating
> > the query string w/
> >
> > sprintf(query, "INSERT INTO support
Angus,
On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a very
> vague error: something about a problem "near '' on line 1". I'm forumating
> the query string w/
>
> sprintf(query, "INSERT INTO support_files (sessio
use mysql_real_query(), which is where
the error is returned. From what I can tell from the on-line documentation,
this is the right way to handle blobs. I also tried:
sprintf(query, "INSERT INTO support_files (session_id,file_type,file_body)
VALUES (%ld,%ld,0)", sessionID,fileType); //
I usually use ps.setBytes() and pass it a byte[] array ..
On Wed, 22 Oct 2003, Scott Purcell wrote:
> Hello,
> I have opted to insert some small jpg files into the mysql database using java.
> Code below.
>
> When I do a select from the table using the mysql> command line, it generates
> pages
Hello,
I have opted to insert some small jpg files into the mysql database using java.
Code below.
When I do a select from the table using the mysql> command line, it generates
pages of
---
On Sun, 2003-03-02 at 21:19, Aaron O'Neil wrote:
> How-To-Repeat:
>
> I suspect there is a bug in the ODBC driver in relation to blobs. I'm now
> using 3.51.06, but was having this same problem on 3.51.05.
>
> I'm using Visual C++ and their CRecordset wrapper fo
How-To-Repeat:
I suspect there is a bug in the ODBC driver in relation to blobs. I'm now
using 3.51.06, but was having this same problem on 3.51.05.
I'm using Visual C++ and their CRecordset wrapper for the ODBC calls. I'm
using the positioned updates.
As long as I keep the binary
On Fri, Jan 10, 2003 at 04:36:07PM -0600, Terry & Cheryl Haimann wrote:
> Is there an easy way to see If and how much data I have written into a blob?
You can find the length of a blob in bytes using the LENGTH function:
SELECT LENGTH(column) FROM table;
You can also use BIT_LENGTH to fi
At 16:36 -0600 1/10/03, Terry & Cheryl Haimann wrote:
Is there an easy way to see If and how much data I have written into a blob?
LENGTH(blob_col_name) might be what you want.
sql...tomakefilterhappy
-
Before pos
Is there an easy way to see If and how much data I have written into a blob?
sql...tomakefilterhappy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Tue, 13 Aug 2002, Mauricio Sthandier R. wrote:
> I'm working with BLOBs in mySQL and Visual Basic... i read that
> storing images in the database has worst performance than the
> filesystem, but anyway I'm planning to store them in MediumBlobs. My
> specific problem i
a database. And it's human readable.
Serge.
- Original Message -
From: "Mauricio Sthandier R." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 9:35 AM
Subject: BLOBs and DataBase... is it likely to corrupt i
I'm working with BLOBs in mySQL and Visual Basic... i read that storing
images in the database has worst performance than the filesystem, but anyway
I'm planning to store them in MediumBlobs.
My specific problem is that I don't know if I'm risking too much the
database, perhap
:Lets say the image is 400 x 300 px and I would like tor resize the image to
:40 x 30.
:Is there a way without php or similar?
Go with ImageMagick. It has a imaging resizing and cropping functions
:
:Maybe someone has done this already and can give me a hint on that.
:
:Thanx in advance,
Hi there,
I am wondering if it is anyhow possible to resize an image stored in a blob
field.
Lets say the image is 400 x 300 px and I would like tor resize the image to
40 x 30.
Is there a way without php or similar?
Maybe someone has done this already and can give me a hint on that.
Thanx in
on 5/21/02 2:09 PM, Jim Philips at [EMAIL PROTECTED] wrote:
> On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote:
>> Any suggestions on how to load images from a web site into a MySQL db? I
>> would like to set up a page that allows you to select an image from the
>> local machine and load it t
On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote:
> Any suggestions on how to load images from a web site into a MySQL db? I
> would like to set up a page that allows you to select an image from the
> local machine and load it to my MySQL DB on my web server.
>
> I'm not sure if it would just
TED]>
Sent: Tuesday, May 21, 2002 10:54 AM
Subject: Inserting images and other blobs
> Any suggestions on how to load images from a web site into a MySQL db? I
would like
> to set up a page that allows you to select an image from the local machine
and load
> it to my MySQL DB on my web
Any suggestions on how to load images from a web site into a MySQL db? I would like
to set up a page that allows you to select an image from the local machine and load
it to my MySQL DB on my web server.
I'm not sure if it would just be a regular insert statement or something else?
Thanks..
Why store the pic in the DB?
I know there is an ASP upload utility avaliable.
Try www.asp101.com or www.hotscripts.com
HTH
Mark
-Original Message-
From: Zill-e-Hassan <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, April 25, 2002 1:48 PM
Subjec
application look at a sample of what SciBit developed for an Anglo
American company called Anglo Platinum: http://www.scibit.com/sepix everything you
see in this webbased app sample is from a sample MySQL database and accessed only with
MySQLX. From the tables, PDF reports to the images (in BL
-Hassan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: Blobs+ASP+MySQL
Dear All
I have been trying to find out if there is a way of actually storing
pictures as Blobs in MySql . Eventually i want to upload and download
pictures to/from the database
Dear All
I have been trying to find out if there is a way of actually storing
pictures as Blobs in MySql . Eventually i want to upload and download
pictures to/from the database through the use of ASP. I would also welcome
any suggestions that you guys may have regarding how to upload the image
> Just a noob question... (I suppose)
>
> When I try just putting php code in my insert query, it goes like this:
>
> insert into mytable values('')
>
> select * from mytable, returns:
> Some string
>
> Any help would be greatly appreciated!
>
I think if you write php code in to text file (or php
Just a noob question... (I suppose)
When I try just putting php code in my insert query, it goes like this:
insert into mytable values('')
select * from mytable, returns:
Some string
Any help would be greatly appreciated!
-
B
Hisseine,
Thursday, April 11, 2002, 5:21:09 PM, you wrote:
HD> Does MySqL database supports BLOBs operation? (Insert, delete etc ...)
HD> If yes which API can use to do these operations? (MySqL++)?
BLOB are just the same thing as other field types. You can use
INSERT, UPDATE, DELETE stat
Thanks Paul,
Hisseine
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Hisseine Dj." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 10:40 AM
Subject: Re: About BLOBS
> >Hello,
> >
> &
>Hello,
>
>Does MySqL database supports BLOBs operation? (Insert, delete etc ...)
Yes.
>If yes which API can use to do these operations? (MySqL++)?
Any. BLOB columns are just character columns. They need not be
accessed in separate hunks like in some other databases.
>
&
Hello,
Does MySqL database supports BLOBs operation? (Insert, delete etc ...)
If yes which API can use to do these operations? (MySqL++)?
Thanks for help
-
Before posting, please check:
http://www.mysql.com/manual.php
> Adriano Manocchia wrote:
> Well, first off, I can't seem to get max_allowed_packet higher than 64
> MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are
> reflected in the system settings, but only up to 64 MB, then regardless
> of what I put in there, it stays at 64 MB. Bu
for
> AM> smaller files. The field is a longblob, BTW. Any help would be
> greatly
> AM> appreciated. And please don't tell me not to store large blobs in
> the
> AM> database. I wouldn't be doing it if I didn't have to.
-
gt; DBD::mysql::st execute failed: MySQL server has gone away
AM> when it tries to do the insert or update. It continues to work fine for
AM> smaller files. The field is a longblob, BTW. Any help would be greatly
AM> appreciated. And please don't tell me not to store large blobs in
do the insert or update. It continues to work fine for
> smaller files. The field is a longblob, BTW. Any help would be greatly
> appreciated. And please don't tell me not to store large blobs in the
> database. I wouldn't be doing it if I didn't have to.
>
> Age
>
x27;t tell me not to store large blobs in the
database. I wouldn't be doing it if I didn't have to.
Age
---
Adriano "Age" Manocchia [EMAIL PROTECTED]
Cornell University AIM/Yahoo/MSN: S
>
> How do I insert files inte BLOBs?
>
Tomas,
I use this PHP function to insert ASCII files into BLOBs. I think it would
also work for binary files but I have not tested it. Please note that there
are other (perhaps better) ways to insert into BLOBs but this works for me.
Good luc
inte BLOBs?
Maybe it would be better to still use a 'real' directory tree and just keep
track of the privileges with mysql? I don't know. pointers, please
regards, tomas
ps. this is my first post on this mailinglist, if you find this kind of
post/post-formatting unacceptable let
Hi-
I apologize for being unclear. It is messing with the text update log. I have
both binary and text logging running right now while I try figure this out.
However I have since learned that the database that is writing the blobs is
related to Resin JSP session data, and so does not need to
Hi-
I apologize for being unclear. It is messing with the text update log. I have
both binary and text logging running right now while I try figure this out.
However I have since learned that the database that is writing the blobs is
related to Resin JSP session data, and so does not need to
Hi-
I apologize for being unclear. It is messing with the text update log. I have
both binary and text logging running right now while I try figure this out.
However I have since learned that the database that is writing the blobs is
related to Resin JSP session data, and so does not need to
On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote:
> Is there SQL syntax to do selective logging. We have logging
> turned on, but queries involving BLOBS tend to screw with the
> logs. Any help would be useful
Can you be more specific than "screw with the logs&qu
Hi-
Is there SQL syntax to do selective logging. We have logging turned on, but
queries involving BLOBS tend to screw with the logs. Any help would be useful
TIA,
-Dan
-
Before posting, please check:
http
I am appending blocks of binary data to an existing BLOB in a database. The
blocks are coming at me in 1000 to 3000 bytes chunks and the BLOB can grow to
a few meg easily. I am using the sql command (from PHP):
UPDATE MyTable SET MyBlobField=CONCAT(MyBlobField,"--escaped binary data
here--")
T
At 10:09 -0700 3/1/02, Hector Rosas wrote:
>Hello, look I'm trying to insert an Image into a blob field with a
>Normal insert query. I know that the information that will be
>contained on the blob field should be between " (quotation marks),
>but if inside the info of the image is a quotation m
Hello, look I'm trying to insert an Image into a blob field with a Normal insert
query. I know that the information that will be contained on the blob field should be
between " (quotation marks), but if inside the info of the image is a quotation mark
it should be escaped with a \ (back slash).
I posted a problem I was having with this, but unfortunately nobody
responded. Regardless, here are the methods I've used:
1) using LOAD_FILE():
INSERT INTO table_name (column_name)
VALUES(LOAD_FILE('/absolute/path/to/file'));
In windows, of course, the path to the file should p
I need to store large files in a MySQL database (in Windows). To do
this, I have created a table that has a BLOB column. How can I insert
the files into this table?
Thanks,
Ron
-
Before posting, please check:
http
Is there any way to hex-dump a BLOB column using a Select statement on the
mysql command line?
The documentation for the "hex()" function says that
hex("abc")
should print
616263
But in fact it prints 0. (on 3.23.36 and 3.23.43, the two versions I have
installed - the former on RedHat
>Hello! How do I get the size of a blob?
>I want to do something like this:
>SELECT * FROM blob_table WHERE size(blob_column) > 1024;
replace "size" with "LENGTH" and it will work.
SELECT * FROM blob_table WHERE LENGTH(blob_column) > 1024;
Giuseppe Maxia
Hello!
How do I get the size of a blob?
I want to do something like this:
SELECT * FROM blob_table WHERE size(blob_column) > 1024;
Best regards
Sven
--
---
>>> ANDURAS AG - solutions for the NET <<<>>> h
Hi All, can someone point me in the right direction for saving
formatted RichEdit Text to a blob field and then loading the RichEdit field
with the data from the blob. I am using Borland Builder 5 odbc to MySQL
database.
Regards
Doug
[EMAIL PROTECTED]
--
On Thu, Aug 23, 2001 at 05:07:35PM -0500, Gary Jollymore wrote:
>
> how would i get a file such as /files/photo.jpg into a mysql table
> such as
>
> create table photo ( code decimal(6,0), photo blob);
>
> i tried insert into photo values('4142','/files/photo.jpg'); which
> of course just put th
how would i get a file such as /files/photo.jpg into a mysql table such as
create table photo ( code decimal(6,0), photo blob);
i tried insert into photo values('4142','/files/photo.jpg'); which of course
just put the file name into the 'photo' column.
gary
[EMAIL PROTECTED]
Warren,
Thanks for your quick reply and help and pointers.
I think that realistically it will take me a while to understand it as it is only part
time (evenings after work) when I can actually do it. Initially, I will try and store
BLOBs rather than use pathnames and separate binaries so my
Hi!
I'm new too, but here are some things I've picked up from others on the List
kind enough to advise:
Regarding blobs, putting even large amounts of material into them is the
same as using any other data type.
Some considerations: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:
Dear all,
Please excuse a newbie question. I am interested in storing articles (up to 300k) in a
database, and some may have formatting and contain graphics like a word document. Is
it possible to do this in mySql and if so e.g. in a TEXT or BLOB field, how do I store
an article and then retri
hi ... how can i build queries that save the value of ... for example
jpg-files ?
in their binary-code there are many '\0' - characters which terminate a
string ... so how can i tell the mysqlserver to save it anyway ?
-
Before
On Tue, Mar 13, 2001 at 04:18:41PM +0100, Alessandro de Manzano wrote:
> I'm planning to deploy MySQL for a project of my company but I've some
> concern about real size limit of BLOBs.
>
> I read on Paul DuBois' excellent book that longblob are 2^32-1 wide,
>
Hi,
> I read on Paul DuBois' excellent book that longblob are 2^32-1 wide,
> but actually the communication _protocol_ between clients and server
> limits to 24Mb the dimension of a single record.
>
> What workarounds could I use ?
A simple workaround is that you store the binary data as files o
Hello!
I'm a beginner of the wonderful world of MySQL :-)
I'm planning to deploy MySQL for a project of my company but I've some
concern about real size limit of BLOBs.
situation: MySQL 3.23.33 on FreeBSD 4.2-stable, clients are near always
Win machines with MyODBC and propr
Well, if you have other varchar fields in your table, then it probably
wouldn't have any impact on performance. But since BLOBS and TEXT are
considered varchar, the table no longer is a fixed width. It is my
understanding that MySQL can locate specific records faster (even with
indexe
1 - 100 of 104 matches
Mail list logo
