How to store jpg in mySQL?

guy

Hi,
How do I store pictures in mySQL? What is the data type for this field?

TIA

Jul 19 '05 #1

Subscribe Reply

7552

Aggro

guy wrote:

How do I store pictures in mySQL? What is the data type for this field?

blob, but as you can see from the question below, saving files into
database, can lead you into troubles later. It is easier just to save
link to the file, or just filename, or even just a number that
identifies the file. And save the files in some local folder from where
they are loaded when needed.

Jul 19 '05 #2

Aggro

guy wrote:

How do I store pictures in mySQL? What is the data type for this field?

Jul 19 '05 #3

Aggro

guy wrote:

How do I store pictures in mySQL? What is the data type for this field?

Jul 19 '05 #4

Similar topics

1142

Can MySQL 4.0.14 store HTML? Among other things....

by: Machiste' N. Quintana | last post by:

Hey. I'm New (as you probably can tell), and I was wondering if MySQL 4.0= =2E14 can store HTML, PHP, JavaScript and/or Flash. Can it? I'm assuming it wou= ld be stored as a string, and if...

MySQL Database

1944

FW: Can MySQL 4.0.14 store HTML? Among other things....

by: Donald Tyler | last post by:

Yes it can. But you should understand the three distinct levels of that situation. You need the following: Database Web Server Server-Side Scripting Language I would suggest using AMP...

MySQL Database

8561

How to store an array in the MySQL?

by: jacob nikom | last post by:

Hi, I would like to be able to store numerical array in MySQL. I am really looking for the solution to store it in the one field only. For example, I have a matrix, which I want to store in...

MySQL Database

7692

What is the best way to store XML file in MySQL?

by: jacob nikom | last post by:

Hi, I would like to store XML files in MySQL. What is the best solution: 1. Convert it to string and store it as CLOB/text 2. Serialize it and store as byte array 3. Flatten it out and create...

MySQL Database

1769

XMLS,MySQL,PHP Generate & Store

by: Kyndig | last post by:

Hi group, I am working on retrieving/storing information in a MySQL database that requires the rows of the db scheme to be expandable. As an example of what I am trying to do: You want to store...

PHP

1452

How to store and retrieve array of bytes MYSQL

by: Gert | last post by:

Hi, I need to store a array() of byte to a mysql field. I created a field in mysql of type varbinary. But storing and retrieving gives problems. Please help. The strTemp = EnDeCrypt(txt,...

ASP.NET

3356

how do I store a binary file in a MySql database, as a string?

by: lawrence k | last post by:

I'm a little weak on my basic I/O. Help me out please. Is it right to say that I can just open any file with file(), get it as a string, and then store in a MySql database, in, say, a MediumText...

PHP

17871

How to get data from .CSV file using php & store it into Mysql database

by: mukeshpatil | last post by:

How to get data from .CSV file using php & store it into Mysql database I want to read data from two different .CSV files using php & How to store it into Mysql Database tables Please help me...

PHP

5082

Corrupted images after attempting to store PNG images as BLOBs inMySQL?

by: Keith Hughitt | last post by:

Hi all, I've run into a strange error while trying to store some PNG images in a MySQL database using MySQLdb. When I try to insert smaller images (< 64kb or so) everything seems to work fine....

Python

2527

permanently store balance result in a field of current table

by: darendaren88 | last post by:

MySQL Database

7198

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7072

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7271

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7319

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

4998

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4666

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3149

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1498

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

730

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP