ase.utf8.sql $ iconv
>> -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo "SET
>> NAMES utf8;" > tmp.sql
>> $ cat mydatabase.utf8.sql >> tmp.sql
>> $ mv tmp.sql mydatabase.utf8.sql
>>
>> I've one question :
&
"SET NAMES utf8;" > tmp.sql
> $ cat mydatabase.utf8.sql >> tmp.sql
> $ mv tmp.sql mydatabase.utf8.sql
>
> I've one question :
>
> * if my database have some blob field with binary data (like image...),
> iconv convert also this data then this data will be
I've break line misteak in my previous message, this is the fix :
$ mysqldump --user=root --password=password --host=mybox mydatabase --
default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump --
user=root --password=password --host=mybox mydatabase
--default-character- set=latin1 > mydata
#x27;ve one question :
* if my database have some blob field with binary data (like image...),
iconv convert also this data then this data will be corrupted ?
Thanks for your information,
Stephane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
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 en
Hi,
As my mysql command line utility aborts when searching for certain
characters in a binary field (it affects bash as well), I decided to
convert these characters via CHAR(character) instead, like this:
select binary_column from my_table where binary_column like CONCAT
(CHAR(3),'pR',CHAR
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't l
he InnoDB engine,
which is not prone to corruption in the same way as MyISAM.
I don't have experience storing large amounts of binary data, so I can't
say anything about MySQL's performance in that area specifically.
2. Can I implement this using regular SCSI disks wit
Cabbar Duzayak wrote:
> So my questions are:
>
> 1. The main question is, do you guys have any experience with this
> much binary and regular data? Do you think Mysql can handle this much
> data in a reliable manner (without corrupting data and/or
> degrading/terrible performance) ?
I would say
://www.criticalcode.com
-Original Message-
From: Cabbar Duzayak [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 09, 2005 12:01 AM
To: mysql@lists.mysql.com
Subject: Storing huge amount of binary data
Hi Everyone,
I will be starting a project for which I will need to store about 1 million
Hi Everyone,
I will be starting a project for which I will need to store about 1
million image files all of which are about 50-100K in size. I will be
using Linux for this project. The database won't be very busy, there
will be batch image uploads 1-2 times a day, and around 100-200
concurrent use
]
Sent: Tuesday, March 01, 2005 5:09 PM
To: [EMAIL PROTECTED]; mysql
Subject: Re: Inserting Other Binary data into DB (NOT IMAGES)
Inserting Other Binary data into DB (NOT IMAGES)Inserting images in no
different compared to inserting PDFs.
What is your problem? What have you tried so far?
With
Inserting Other Binary data into DB (NOT IMAGES)Inserting images in no
different compared to inserting PDFs.
What is your problem? What have you tried so far?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
Title: Inserting Other Binary data into DB (NOT IMAGES)
Good afternoon all,
I have a db (gasp!) that is holding images in a BLOB field already. I can upload and retrieve on the fly - no problems.
Now I am looking at inserting binary data such as M$Word Documents (.doc and .rtf
Hi,
I'd like to insert binary data from a series of image files into a blob
column using a sql statement. I have working examples from jsps / java
but I'd like to write a sql script to do the same.
I've had a look at the load data infile commands but they only seem to
rela
Hi Folks --
Been working on this issue for a while, and not making much headway, so I
thought I'd throw it out to the list and see what wisdom came back :)
Problem: I'm trying to find a way to store LOTS of scientific data (mostly
32-bit integers and floating point numbers) in a database for an
ks are always removed, it means
> CHAR/VARCHAR could never store binary data then...
>
> Is there a 128-bit datatype planned? It would be handy to store
> GUID/UUID or IPv6 addresses.
You can use a TINYBLOB, which will consume 9 bytes (due to the length
byte), or you can use two BIG
removed, it means
CHAR/VARCHAR could never store binary data then...
Is there a 128-bit datatype planned? It would be handy to store
GUID/UUID or IPv6 addresses.
--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Can CHAR/VARCHAR store strings with nul (ASCII 0) in them? It seems it
can't. [I've used CHAR(2), VARCHAR(2), CHAR(2) BINARY, VARCHAR(2) BINARY].
===
create table t1 (
id int not null primary key,
code varchar(2) not null, un
I am trying to upload an icon from a client to a server and then to
other clients over tcp/ip. the icon data will be stored in mysql on the
server. the column is defined as a mediumblob field. once on the
server, i escape the string and then put it into a mysql statement to
insert it into the d
are there any issues regarding special characters that
should be escaped when storing binary data in a BLOB
field? any special ascii codes that must be checked
for before inserting data into a table?
i remember reading something about ascii(26) causing
some problems when using mysqldump and
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 befor
shouldn't be an issue.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Stefan Hinz" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, 07 June, 2003 03:25
Subjec
Brad, Edward,
> Try using 'max_allowed_packet=16M' instead of your current value. You may also
> find help by reviewing the below.
> http://www.mysql.com/doc/en/Packet_too_large.html
That will set the communication buffer to a maximum of 16 MB, but Brad
wants more than that ... From the manual:
ally considered better practice to do the
latter.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 06 June, 2003 17:11
Subject: Please help: Can not insert binary data larger than 16 megaby
Hello --
I am having trouble inserting binary data that is larger than 16
megabytes into a MySQL database table (binary data such as pdf's, gif's,
jpeg's, etc). Can someone take a look at what I am doing and give me
any suggestions.
If I do insert binary data larger than 16 mega
imaginable.
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 12:53 PM
To: [EMAIL PROTECTED]
Cc: Adam Clauss
Subject: RE: How to fill an Blob with binary data
Depending on size of data there are a few different
03 7:14 PM
> > To: Thomas Hoelsken
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: How to fill an Blob with binary data
> >
> >
> > Mascon can do it .. it's a win32 app..
> >
> > On Tue, 27 May 2003, Thomas Hoelsken wrote:
> >
> > >
Depending on size of data there are a few different methods... Just like
what most people do.. use plain insert statements with the data properly
escaped and shouldn't have any problem going in.
Pulling data out is pretty quick .. I can stream binary data out of my
mysql storage servers vi
Copied from my original message:
I am writing a database that will contain a blob field for some binary data.
My question is, what is the most efficient way to load this binary data in?
I could turn it into a string and pass it into an INSERT/UPDATE statement,
but I am afraid that problems will
In what language?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Clauss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 11:30 AM
To: Mike Hillyer; [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
In my case, its neither. Some "random" b
What is the source of the binary data you want to use to fill the blob?
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 12:23 PM
To: Adam Clauss; [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
Like I said, for Image and
In my case, its neither. Some "random" binary data. Could be ANY kind of
file... (I'm doing mine programmatically).
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 12:23 PM
To: Adam Clauss; [
s Hoelsken
> Cc: [EMAIL PROTECTED]
> Subject: RE: How to fill an Blob with binary data
>
>
> Mascon can do it .. it's a win32 app..
>
> On Tue, 27 May 2003, Thomas Hoelsken wrote:
>
> > Hi,
> >
> > isn't there any other solution instead of usin
On 27 May 2003 at 19:10, Thomas Hoelsken wrote:
> isn't there any other solution instead of using PHP just for filling
> an Blob!?
Of course there is, but if you need more specifics you need to give
us more details. How are you executing your SQL statements? It's
just a matter of getting your
Like I said, for Image and text blobs, use MyCC and it should work.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Clauss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
I am in need of
: How to fill an Blob with binary data
Hi,
isn't there any other solution instead of using PHP just for filling an
Blob!?
I don't need php and would prefer any other way!
Thanks,
Thomas
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Se
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, May 27, 2003 6:56 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: How to fill an Blob with binary data
> >
> >
> >
> > Search the mail
; To: [EMAIL PROTECTED]
> Subject: Re: How to fill an Blob with binary data
>
>
>
> Search the mailing list archives for this... There is a link to this
> article:
>
http://www.php4.com/forums/viewtopic.php?t=6
I wonder if the mailinglist search was powered by google mor
data
Hi,
I would like to fill an Blob with binary data thru SQL-statements or any
other MySQL tools and don't know how!?
Are there suggestions?
Thanks,
Thomas Hoelsken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
l an Blob with binary data thru SQL-statements or any
> other MySQL tools and don't know how!?
>
> Are there suggestions?
>
> Thanks,
> Thomas Hoelsken
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To un
Hi,
I would like to fill an Blob with binary data thru SQL-statements or any
other MySQL tools and don't know how!?
Are there suggestions?
Thanks,
Thomas Hoelsken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
7;t too great.
Just a pointer..
--
Aigars
-Original Message-
From: Bruno Batarelo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 20:37
To: [EMAIL PROTECTED]
Subject: MySQL BLOB fields and large binary data
Greetings
Seemingly MySQL has a persistant problem that I could no
Greetings
Seemingly MySQL has a persistant problem that I could not solve whatever I
tried to do. It seems that it is impossible to send large amount of binary
data to mysql's BLOB field. It is written in manual that 4.0x versions do
not have limit for max_allowed_packet. It is also written
lose
Set rsImage = Nothing
Response.Write "File was successfully uploaded..."
Response.Write ""
Else
Response.Write "No file was selected for uploading"
Response.Write "..."
End If
I'm almost sure this error arises because the class object used for the
Wixson [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 10:29 AM
To: [EMAIL PROTECTED]
Subject: Binary Data and BLOB Problem
Having trouble with my first MySQL database. I want to upload and install
image files to a database for online sample photo gallery for our
customers. The system
Having trouble with my first MySQL database. I want to upload and install
image files to a database for online sample photo gallery for our
customers. The system I've created so far sometimes works, sometimes
doesn't. It seems to depend on the size of the file being uploaded, but
tests have be
:
Hi,
I would like to know how to store binary data as images, sounds, Rich Text
Format, pdf-files, as BLOB in MySQL. (from
Delphi).
Sincerely,
Adrian Tarniceru
-
Before posting, please check:
http://www.mysql.com/manu
Hi,
I would like to know how to store binary data as images, sounds, Rich Text
Format, pdf-files, as BLOB in MySQL. (from
Delphi).
Sincerely,
Adrian Tarniceru
---
Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV
record_buffer=1M -O max_allowed_packet=24M
-Borries
>
> I am using Qt 3.0.5's QSql database classes to store
> information in a MySQL database. MySQL is at version
> 3.23.49. I am trying to store binary data into a
> column marked as MEDIUMBLOB (or even LONGBLOB) but am
&
> Whenever I insert data that is
> around 1 Megabyte in size, I get an error saying
> "MySQL server has gone away". It doesn't happen with
> smaller data, and even if I change the column type to
> LONGBLOB I still have this problem.
You've hit the default maximum packet size of 1 MB.
This is a pr
- Original Message -
From: "Steven Nakhla" <[EMAIL PROTECTED]>
To: "QT" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 3:47 PM
Subject: MySQL and binary data
> I am using Qt 3.0.5's QSql dat
I am using Qt 3.0.5's QSql database classes to store
information in a MySQL database. MySQL is at version
3.23.49. I am trying to store binary data into a
column marked as MEDIUMBLOB (or even LONGBLOB) but am
having difficulties. Whenever I insert data that is
around 1 Megabyte in size,
I've been using MySQL now for around a month. I also administer the system
where our MySQL implementation is installed. Each night, we perform a full
file system backup around 11:50PM. I just noticed that our MySQL root data
directory is filling up with binary data files named so:
`hos
it's true that mysql-4.x process binary data well when not using multi-byte
charset
but mysql-4.x process it differently when using multi-byte
it's only for GBK text escaping, which is not suitable for binary data
that's the key point
if u don't use multi-byte, and mysql-4.
Binary data is binary data.
It doesn't mattrer whether it is GBK or and audio file,
or a jpeg.
If you escape the data properly before inserting it you will get
back the same data you stored.
Your application must display it properly.
xuefer tinys wrote:
> re-posting multibyte problem.
re-posting multibyte problem.
does anyone have problem with binary data in MySQL-4.x using GBK charset or
any other multibyte charset?
inserting/updating/replacing
the full description is in mysql mailing list archive, sent by me
will not repost full desc until someone have or care this
em is that some of
the binary data could make the insert impossible to be
executed. What I would try is to export the data as a
delimited file, then you will have to files, one with
your database structure (that you will run first) and
another one with the data (delimited by something).
Take a look on
Just for those people who have the same problem:
-Original Message-
From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 11:13
To: Bert VdB
Subject: Re: Binary data mysqldump and restore.
That did it thanks!
MWP
> Hi,
>
> Have you tried making a
Hi all...
!! First, can you CC to [EMAIL PROTECTED], as im not on the mailing list.
I have a few tables which are storing a few MB of binary data (like jpegs).
I can dump the db fine using mysqldump, but on doing a "mysql ... < dumpfile" i get
many errors, as it seems mysql isnt
Most people usually will just select the data and then do whatever
> needs to be done in the language you are writing your application in.
> It would be like a 5 line script in either perl or php. Hope this
> helps you out some.
>
> Harrison
>
>
> Miles Martin wrote:
>
need some help with. I am trying to insert binary
>data into a mysql database and simply retrieve it. each time I retrieve the
>data, it is corrupt. What am I doing wrong?
>
>I am running mysql 3.23.41 on Red Hat Linux release 7.2 (Enigma) Kernel
>2.4.7-10 on an i686.
>
>My tabl
Hello there,
I have a problem that I need some help with. I am trying to insert binary
data into a mysql database and simply retrieve it. each time I retrieve the
data, it is corrupt. What am I doing wrong?
I am running mysql 3.23.41 on Red Hat Linux release 7.2 (Enigma) Kernel
2.4.7-10 on
have a table that contains both character and binary data. I am
> reading rows from the table using the function mysql_fetch rows() in a
> C program. I can obtain character data all right, but I cannot obtain
> the values of binary data stored in the table as type DOUBLE. My co
32 PM
Subject: Problem with binary data in row
> Hello all, I posted this question yesterday but received no feedback so
> I decided to ask again.
>
> I am new to MySQL and I am trying to access binary data stored in a
> MySQL table using a C program. The table looks like this
Michael Flora wrote:
> Hello all, I posted this question yesterday but received no feedback
> so I decided to ask again.
>
> I am new to MySQL and I am trying to access binary data stored in a
> MySQL table using a C program. The table looks like this:
>
>
> date
Hello all, I posted this question yesterday but received no feedback so
I decided to ask again.
I am new to MySQL and I am trying to access binary data stored in a
MySQL table using a C program. The table looks like this:
date date
double firstfield
double secondfield
double thirdfield
My
Hello all, this is my first post to this list. I am relatively new to
MySQL, and my question might be a basic one.
I have a table that contains both character and binary data. I am
reading rows from the table using the function mysql_fetch rows() in a C
program. I can obtain character data
are you null terminating the string?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sameer Maggon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 7:51 AM
Subject: Binary Data mysql_real_escape_
> Hi,
> Ple
Hi,
Please see the code given below::
//
strcpy(query,"INSERT INTO blobtest VALUES('abc','");
qptr = query;
len = strlen(query);
qptr += len;
qptr += mysql_real_escape_string(&mysql, qptr, data, iBytesRead);
*qptr += '\'';
*qptr += ')';
mysql_rea
If a table has a blob type containing binary data, like jpeg images or PDF
files for example, can mysqldump be told to encode the data so it is ASCII
compatible? (using uuencode or something like that..)
I am not sure of the 'right' way to do this, but some informal tests where
On Sun, Mar 10, 2002 at 09:59:09AM +0200, Toomas Vendelin wrote:
> It doesn't look "same way" :(. Normally I've read data from a file
> on a client's machine using Perl's read function like this
>
> while(read($file, $data, 1024))
> {
> print TO $data;
> }
>
> to write it from $file on cli
o open a filehandle to a database field and then
"print" to it? :).
Regards,
Tom
Saturday, March 09, 2002, 9:00:08 PM, you wrote:
PD> At 16:39 +0200 3/9/02, [EMAIL PROTECTED] wrote:
>>Hello.
>>
>>How to load binary data into a table using
>>Perl DBI module (t
At 16:39 +0200 3/9/02, [EMAIL PROTECTED] wrote:
>Hello.
>
>How to load binary data into a table using
>Perl DBI module (the data is uploaded from a HTML
>form)?
Same way you load any other kind of data. Use placeholders or the quote()
function.
>
>I failed to find any
Hello.
How to load binary data into a table using
Perl DBI module (the data is uploaded from a HTML
form)?
I failed to find any information on MySQL site.
Thanks in advance.
-
Before posting, please check:
http
Hello, I'm new to Unix and MySQL.
I would like to store binary data in MySQL, but cannot find any sample code
on how to go about doing this in C.
The binary data is variable size ranging from 3k to 10k. I want to store it
in a row along with a User ID so I can retrieve it by doing a que
On Fri, 14 Dec 2001, Ian Collins wrote:
>
> I am having difficulties with entering binary data from a c program.
> I have passed the string through mysql_real_escape_string.
Post the C data then. However read on.
>
> . . .
>
> drop table if exists junk5;
>
> create
(The following was done in mysql_4.0 alpha)
I am having difficulties with entering binary data from a c program.
I have passed the string through mysql_real_escape_string.
What I am seeing is that if the binary data contains an ascii 0, then
mysql_real_escape_string, correctly, translates it
I use MySQL rpm to install in RedHat 7.2 in one of
my pc. Then I store binary data such as image in
MySQL and it works normally.
However, I install source MySQL in RedHat 7.2 in
another pc. But it cannot store binary data.
Does anybody know the reason? Is that it need some
special configure
At 6:59 PM -0700 10/23/01, Bob Purvy wrote:
>I'm doing just general feasibility studying of embedding MySQL in a
>networking product, and I have a question that I haven't been able
>to find the answer to after a fair bit of looking
>
>- is there some way to insert data that is already in IN
I'm doing just general feasibility studying of embedding MySQL in a
networking product, and I have a question that I haven't been able to
find the answer to after a fair bit of looking
- is there some way to insert data that is already in INT UNSIGNED
form directly into a table, without c
is big object,with the same paramete (16 megs
stack size)of jvm ,I can send 50 megs file to database!
I think the mysql may be improve on this point.
>From: "Mark Matthews" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subjec
ented.
On Fri, 21 Sep 2001, Mark Matthews wrote:
> Date: Fri, 21 Sep 2001 08:14:45 -0500
> From: Mark Matthews <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: Faliue: Write huge binary data to blob Field of mysql use jdbc
>
> Hi, I
m some other type of server
(HTTP/NFS, etc), then you've more than doubled your overhead with the
over-the-wire costs. RDBMS systems are not optimized for storing and
retrieving large binary data, filesystems are.
What you probably want to do is generate some unique identifier for the file
and
o: "'Àî Çà'" <[EMAIL PROTECTED]>
>CC: "mysql mailing list (E-Mail)" <[EMAIL PROTECTED]>
>Subject: RE: Faliue: Write huge binary data to blob Field of mysql use
jdbc
>Date: Thu, 20 Sep 2001 16:29:27 +0200
>
>Hi ? ?
>
> > -Original
Hi ? ?
> -Original Message-
> From: ? ? [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 12:12 PM
> To: [EMAIL PROTECTED]
> Subject: Faliue: Write huge binary data to blob Field of
> mysql use jdbc
>
>
> Hi all:
>
> We are making
Hi all:
We are making a project about "document manage " ,I use org.gjt.mm.mysql
as jdbc to communicate with mysql. I can succeed in writing the binary data
(the size about 14M) to database ,but when I write the binary data that's
size exceed 20M I get a Exception. Please
On Thu, Jul 12, 2001 at 01:51:29AM +0200, Werner Stuerenburg wrote:
>
> Im my understanding, you are storing images. AFAIK, images should
> not be stored in the db but in the filesystem.
There's nothing wrong with doing it, as long as you understand what
you're doing. After all, images are (from
Mittwoch, 11. Juli 2001, 23:45:03:
> Hi,
> I am trying to store fax images in mysql (they are about 1K per page), which
> comes in as binary data. I am able to use mysql_escape_string(data, fax,
> sizeof(fax)) to get the data into mysql, as well as only escaping ' and \
> for the q
Hi,
I am trying to store fax images in mysql (they are about 1K per page), which
comes in as binary data. I am able to use mysql_escape_string(data, fax,
sizeof(fax)) to get the data into mysql, as well as only escaping ' and \
for the query string. I have tried both longblob and lon
to this message, and include the entire text of it in the
>reply, your reply will go through. However, you should
>first review the text of the message to make sure it has something to do
>with MySQL. You have written the following:
>
>
>Can anyone tell me if the storage size fo
I am writing a java app that saves binary data into a
mysql BLOB column. I am having trouble escaping
the ascii(0) character. Since Java is unicode,
how do you represent the ASCII 0 character?
Any help is much appreciated. And sorry, but java sucks.
I could do all the escaping in Perl in 1
Hello List,
I'm going to be storing a LOT of MP3's in a MySQL db, what's the best field
type to use? Blob?
Thanks,
Tyler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
On 3/27/01 4:54 PM, "WeAreUs" <[EMAIL PROTECTED]> wrote:
>
> Hi!
>
> I enter some .wav encoded (windows) data into a MySql table as follows:
>
> $data = addslashes(fread(fopen($form_data, "r"),
> filesize($form_data)));
>$result=MYSQL_QUERY("INSERT INTO
> b(audio,filename,filesize,file
Hi!
I enter some .wav encoded (windows) data into a MySql table as follows:
$data = addslashes(fread(fopen($form_data, "r"),
filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO
b(audio,filename,filesize,filetype,audio_description) ".
"VALUES
('$data','$form_data_name','$
R Uploading File:".mysql_errno().": ".mysql_error()."$SQL");
}
okie hope that helps!
Teddy
"Robert C. Paulsen Jr." wrote:
> On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote:
> > I have the scripts in php to do this if u want.
>
>
On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote:
> I have the scripts in php to do this if u want.
Yes, that would help! thanks.
>
> "Robert C. Paulsen Jr." wrote:
>
> > How can I put binary data into a MySQL database?
> >
> > I assume th
I have the scripts in php to do this if u want.
"Robert C. Paulsen Jr." wrote:
> How can I put binary data into a MySQL database?
>
> I assume the data type is blob, but I don't see how I can
> use SQL syntax to insert anything but text data. I would
> like to inc
How can I put binary data into a MySQL database?
I assume the data type is blob, but I don't see how I can
use SQL syntax to insert anything but text data. I would
like to include various binary files (tar files, zip files,
image files
Hi Barry,
I do not know what do you use for feeding your database, but in Perl you
shoud use the DBI module, and insert the binary data through bindings.
use DBI;
use strict;
...
my $dbh = DBI->connect("dbi:mysql:image_db", "user", "passw
1 - 100 of 105 matches
Mail list logo
