[ic] price | character varying(20)

Chris Schaub interchange-users@interchange.redhat.com
Thu Apr 11 20:46:01 2002


Hi. It definitely has a database limit of 20chars in postgres. Maybe a
postgress vs mysql issue?

--- Brendan Crosser-McGay <brendan@paymentonline.com> wrote:
> the price column in specific option shouldn't have any length.. I've put a
> string there like : red=20.95,blue=19.95,green=99.95 that was huge .. like
> maybe 200 characters in length.. so I dont think theres a limit.
> 
> -----------------------------------------
> Brendan Crosser-McGay
> brendan@paymentonline.com
> -----------------------------------------
> 
> 
> > -----Original Message-----
> > From: interchange-users-admin@interchange.redhat.com
> > [mailto:interchange-users-admin@interchange.redhat.com]On Behalf Of
> > Chris Schaub
> > Sent: Thursday, April 11, 2002 4:58 PM
> > To: interchange-users@interchange.redhat.com
> > Subject: [ic] price | character varying(20)
> >
> >
> > I've noticed that the price column in the options table is
> > limited to 20
> > characters. I've been told that this is where a string of
> > prices for options
> > can be stored. So ...
> >
> > red=20.95,blue=19.95,green=99.95 ...
> >
> > Is this the correct column for this data? Can I make it
> > larger without any
> > effects to the code. Is there another place for this data? Thanks.
> >
> > =====
> > Classical Guitar - Location Recording
> > http://www.schaubguitar.com
> > http://chris.schaub.name
> > http://www.nhzen.org
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Tax Center - online filing with TurboTax
> > http://taxes.yahoo.com/
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@interchange.redhat.com
> > http://interchange.redhat.com/mailman/listinfo/interchange-users
> >
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users


=====
Classical Guitar - Location Recording
http://www.schaubguitar.com
http://chris.schaub.name
http://www.nhzen.org

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/