maximum varchar length

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C51B62.ED21AFC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

Does anyone know how many characters can support the VARCHAR type in =
PostgreSQL?

Thanks, Raul.
------=_NextPart_000_000A_01C51B62.ED21AFC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#e3e1db>
<DIV><FONT face=3DVerdana color=3D#800000 size=3D2>Hello, </FONT></DIV>
<DIV><FONT face=3DVerdana color=3D#800000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana color=3D#800000 size=3D2>Does anyone know how =
many
characters can support the VARCHAR type in PostgreSQL?</FONT></DIV>
<DIV><FONT face=3DVerdana color=3D#800000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana color=3D#800000 size=3D2>Thanks,
Raul.</FONT></DIV></BODY></HTML>

------=_NextPart_000_000A_01C51B62.ED21AFC0--

Raul Secan [ Fr, 25 Februar 2005 16:53 ] [ ID #664071 ]

Re: maximum varchar length

At 10:53 AM 2/25/05, Raul Secan wrote:
>Does anyone know how many characters can support the VARCHAR type in
>PostgreSQL?

The answer is in the documentation:
http://www.postgresql.org/docs/8.0/static/datatype-character .html

the longest possible character string that can be stored is about 1 GB.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Frank Bax [ Fr, 25 Februar 2005 17:24 ] [ ID #664072 ]

Re: maximum varchar length

hi,
does anyone know how to printreports whit PHP, or conect wiht Crystal
Report files.
thanks.

enzo

---------------------------------------------------------
Ab=F3nate a la primitiva. Descubre la forma m=E1s f=E1cil y c=F3moda de hac=
erse millonario. htp://sorteos.ya.com
ADSL + Llamadas 24 horas: desde 28,95 =80/mes + IVA. Navega y habla de form=
a ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamad=
as/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

enzo venegas palacios [ Fr, 25 Februar 2005 22:22 ] [ ID #664073 ]

Re: maximum varchar length

You hijacked a thread - that's a no-no.

At 04:22 PM 2/25/05, enzo venegas palacios wrote:
>does anyone know how to printreports whit PHP,

File - Print.

>or conect wiht Crystal Report files.

ODBC?

http://search.postgresql.org/archives.search?cs=utf-8&fm=on& st &dt=back&q=crystal&ul=http%3A%2F%2Farchives.postgresql. org%2Fpgsql-odbc%2F%25&dp=0&o=0&ps=10&s=date

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Frank Bax [ Fr, 25 Februar 2005 22:35 ] [ ID #664074 ]