On Mon, 2006-08-07 at 09:18 +0100, [EMAIL PROTECTED] wrote:
> what us the maximum filesize for longblobs in kb? Is there anything bigger?
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
As you can see in theory it is about 4GB.
It is however also limited by max_packet_size which
[EMAIL PROTECTED] wrote:
what us the maximum filesize for longblobs in kb? Is there anything bigger?
That's answered in the documentation - http://dev.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
what us the maximum filesize for longblobs in kb? Is there anything bigger?
Ross
Hi
how can i retrieve string value contains in a longblob column ?
i test CAST and CONVERT mysql function but don't work.
Doesn't seem hard but don't see howto do that
select * FROM table
Thank's for any help
--
MySQL General Mailing List
For list archives: http://list
Evewryone,
We are using mysql to store documents. We are using mysqldump to take backups. We have
seen restores of that backups results in corruption of document data. Can anyone tell
me the reason. We have 3.24 lunning on Linux RH7
Thanks
Pankaj Malviya
--
MySQL General Mailing List
For li
uot; <[EMAIL PROTECTED]>
Sent: Friday, May 21, 2004 10:07 PM
Subject: Re: copying longblob value to another table...
> Abubakr wrote:
> > I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of insert
s
Abubakr wrote:
> I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of
insert statement should i use for that purpose.
You should be able to insert into your upload table with a select from
your testing ta
hi,
I am trying to copy a file stored in longblob column of a table to a longblod
column of another table, can any one tell me what kind of insert statement should i
use for that purpose. 2ndly can any one tell me any built in function in mysql to
download a file from longblob column to
Michael Scholz wrote:
Hello,
i stored some files which containing some 0-bytes in longblob fields. If i try to
select the files of these fields, i only get the bytes before the first 0-byte.
I tried this with some clients like MySQL-CC, MySQL-Front, AquaDataStudio and own
java-clients. But
Hello,
i stored some files which containing some 0-bytes in longblob fields. If i try to
select the files of these fields, i only get the bytes before the first 0-byte.
I tried this with some clients like MySQL-CC, MySQL-Front, AquaDataStudio and own
java-clients. But it is always the same
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
>
> Here is the create statement and the resulting table:
>
> mysql> create table test(
>-> myblob longblob) default charset latin1 default collate
> latin1_general_cs;
> Query OK, 0 rows affected (0.08 sec)
>
Here is the create statement and the resulting table:
mysql> create table test(
-> myblob longblob) default charset latin1 default collate
latin1_general_cs;
Query OK, 0 rows affected (0.08 sec)
mysql> show create table test \G
*
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
> I'm using mySQL 4.1.1a-alpha on XP Professional. When I execute a
> create table script containing a COLLATE clause, all LONGBLOB fields are
> silently changed to LONGTEXT in the resulting table. This behavior does
> not
I'm using mySQL 4.1.1a-alpha on XP Professional. When I execute a
create table script containing a COLLATE clause, all LONGBLOB fields are
silently changed to LONGTEXT in the resulting table. This behavior does
not occur on version 4.1.0-alpha.
Is this field type change intentional? I
Im trying to retreive the data from a LONGBLOB column but I have been unable
to convert the binary data back to character data.
Is there something Im not doing right with the query below?
SELECT changehistory.timestamp, SUBSTRING(changedata.changes,1,1000)
FROM changehistory, JOIN changedata ON
Does anyone know of a function to employ when retrieving a LONGBLOB column -
Im creating an ad hoc query and
would like to see the data in text format.
Hi,
It contains only 240 records... I have an another table without longblob
field with much much more records, and the query result is less than one second with
joins!
240 records with 11-15 sec... i think something wrong.
If i start a query, MySQL read 30-40 MB to memory! Why? I think, this
Kiszely Ákos wrote:
Hello list,
I have a MySQL 3.23.49 under Debian Linux with this table:
--
CREATE TABLE `fajl` (
`fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`fajl` LONGBLOB,
`letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(80) DE
Hello list,
I have a MySQL 3.23.49 under Debian Linux with this table:
--
CREATE TABLE `fajl` (
`fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`fajl` LONGBLOB,
`letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(80) DEFAULT NULL,
`fajl_tipus`
hi all
a question about checking the data of a longblob for equality. assume the `data` field
is of type longblob. the following statement returns the image records with equal data.
SELECT * FROM `image` WHERE `data`=?
how does mysql performe the test. does it check the length of the blob
hi:
I will use Mysql 4.0 to store RTP data stream.
How I can get a handle for controlling longblob field? I will put the
received real-time data into the longblob field by the handle
continually.Would you like to write a demo for me?
Thanks for you help
>From: "Ryan @ Common Ground . To" <[EMAIL PROTECTED]>
>
>It seems that MySQL accepts insertion of a string into a BLOB field that is longer
>than the maximum length of the BLOB data-type and it will still accept it.
>
>Perhaps MySQL should output an error or at least a warning to know the string
Ryan,
Tuesday, December 03, 2002, 2:04:03 AM, you wrote:
RCGT> I have successfully inserted and retrieved binary image files within
RCGT> MySQL. No big deal.
RCGT> However, for quite some time I was perplexed because only about half my
RCGT> image was going through.
RCGT> It seems that MySQL a
I have successfully inserted and retrieved binary image files within
MySQL. No big deal.
However, for quite some time I was perplexed because only about half my
image was going through.
It seems that MySQL accepts insertion of a string into a BLOB field that
is longer than the maximum length
¼ÛÅÂÈ£,
Thursday, June 06, 2002, 1:08:07 PM, you wrote:
¼> I will attempt to give you as much information about the software as I can
¼> before I ask the question.
¼> OS : RedHat 7.1
¼> MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
¼> I want to in
Good Day
I will attempt to give you as much information about the software as I can
before I ask the question.
OS : RedHat 7.1
MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
I want to insert into longblob column very big large data.
but.. I have strange Err
Good Day
I will attempt to give you as much information about the software as I can before I
ask the question.
OS : RedHat 7.1
MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
I want to insert into longblob column very big large data.
but.. I have stra
I'm trying to make a copy of a longblob field in an ASP. I'm using this
code:
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs2 = Server.CreateObject("ADODB.Recordset")
SQLStmt = "SELECT `Object` FROM `Objects` WHERE `ID`=" &
hen using it on varchars. But with a longblod, it is not.
> So if the table has column "test longblob" and there is a colum
> where test is set to "xxAbcdx", the query SELECT *
> FROM testtable WHERE test LIKE "%abcd%"; will result in an
> empty s
At 11:56 PM +0200 6/27/01, Tobias Eggendorfer wrote:
>Hi,
>
>I suppose I found a bug :-)
>According to LIKE in a SELECT-query is case-insensitive. In fact,
>it is, when using it on varchars. But with a longblod, it is not.
>So if the table has column "test longblob"
> I suppose I found a bug :-)
> According to LIKE in a SELECT-query is case-insensitive. In fact,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLOB
The only difference between BLOB and
gt; Hi,
>
> I suppose I found a bug :-)
> According to LIKE in a SELECT-query is case-insensitive. In fact,
> it is, when using it on varchars. But with a longblod, it is not.
> So if the table has column "test longblob" and there is a colum
> where test is set to &
Hi,
I suppose I found a bug :-)
According to LIKE in a SELECT-query is case-insensitive. In fact,
it is, when using it on varchars. But with a longblod, it is not.
So if the table has column "test longblob" and there is a colum
where test is set to "xxAbcdx", the
Hello everyone,
I have mySQL 3.23 running on win2000 and encounter the odd
problem: longblob-type field is treated as blob-type since
I cannot put data more than 64kb in size into that field.
Any suggestions are highly appreciated.
Best of luck,
Yuriy Zubarev
On Thu, Mar 01, 2001 at 11:41:52PM +0100, Christiaan den Besten wrote:
> Hi all,
>
Hi, the bugs list is the wrong list I suppose, so I replied to the
mysql list (and you in case you don't read it).
> i've been using mysql for some time now and never had any serious problems I
> could not solve
35 matches
Mail list logo
