[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql
Subject: Re: store file in MySQL database
From: Egor Egorov <egor.egorov () ensita ! net>
Date: 2004-04-30 7:42:18
Message-ID: qjc9m1xr4c.ln2 () blend ! ensita ! net
[Download RAW message or body]
"joe collins" <joe.collins@nuatechnologies.com> wrote:
> I want to store a .txt file in a table in a MySQL database, typically what
> is the best type of data type/ column to use for this. The .txt will not
> exceed 100K.
You need MEDIUMTEXT/MEDIUMBLOB column types:
http://dev.mysql.com/doc/mysql/en/BLOB.html
http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic