Thanks guys. The issue is that users can specify text as well as currency in
the input field ie '£2 students / £5 general admission'.
# [EMAIL PROTECTED] / 2007-01-24 16:58:51 +0100:
> currency values should be stored in the DB as integers (i.e. as penny
> based values). no floats (so that you avoid any rounding errors) and
> definitely no currency symbols!
What about DECIMAL?
> if you need to store which currency the price/a
Dave Goodchild wrote:
> This may be more of a mysql issue, but I am using php for my app so here
> goes...
>
> I have a fee field in the database, and when users post events they can
> specify entrance fee in £. In some, not all, of the fields I am getting,
> for
> example, £7 rather than £. Is t
23 jan 2007 kl. 18.55 skrev Dave Goodchild:
This may be more of a mysql issue, but I am using php for my app so
here
goes...
I have a fee field in the database, and when users post events they
can
specify entrance fee in £. In some, not all, of the fields I am
getting, for
example, £7 r
On Tuesday 23 January 2007 11:55 am, Dave Goodchild wrote:
> This may be more of a mysql issue, but I am using php for my app so here
> goes...
>
> I have a fee field in the database, and when users post events they can
> specify entrance fee in £. In some, not all, of the fields I am getting,
> fo
At 5:55 PM + 1/23/07, Dave Goodchild wrote:
This may be more of a mysql issue, but I am using php for my app so here
goes...
I have a fee field in the database, and when users post events they can
specify entrance fee in £. In some, not all, of the fields I am getting, for
example, £7 rathe
This may be more of a mysql issue, but I am using php for my app so here
goes...
I have a fee field in the database, and when users post events they can
specify entrance fee in £. In some, not all, of the fields I am getting, for
example, £7 rather than £. Is this an encoding issue?
Many thanks
7 matches
Mail list logo
