Re: data type to store a lot of text and tables of data

[Karina Guardado <kguardado@xxxxxxxxx>]

You know I need to design a table where some attributes have a data
type that allow me to store� text mixed with tables and other
information. I use PHP code to get the information and store it in to the database so I wonder if this is posible to do. I found in the link you provided me that� If character varying is used     without length specifier, the type accepts strings of any size. So this is useful for me when only text has to be stored but when the user wants to store information mixed with tables like the following :

Reciba un respetuoso saludo y deseo de �tos en sus actividades. El motivo de la presente es para solicitarle se realice una correcci�n el plan de mantenimiento preventivo y correctivo de fotocopiadoras, duplicadores e impresoras debido a que en el Centro de C�to aparecen, seg� reporte, 4 impresoras asignadas y en realidad solamente tenemos dos que son las que detallo a continuaci�/span>

�

Impresora	Marca	Modelo	No. De Inventario	Observaciones
������ X	HP	LaserJet 1300	12040-3701-080-0005	Si aparece en el listado.
������ X	HP	LaserJet 3055	12040-0603-080-0002	No aparece en el listado

�

I hope this help,

thanks a lot,

karina

On Wed, Mar 24, 2010 at 4:08 PM, Raymond O'Donnell <rod@xxxxxx> wrote:

On 24/03/2010 22:01, Karina Guardado wrote:

> what should be the data type to store a file that can be xls, doc, pdf
> for example.

Sorry, I missed this bit - for binary files you can use the bytea type.
Look under "Binary data types" in the docs.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx