input money values in mysql

[Anon]

Hi friend,

I am working with php 3.0.16 and . mysql 3.23. What I am trying to setup in my table is a  branch for money values format. I live in Brazil and the values for money is like it  1.500,00. I would like to know how can I store this values .

Any idea.

Regards

[Anon]

i think it's best to store money values as simple numbers + currency type. then, when you display values, use currency type to format the number. something like this pseudo-code:

create table SALE (
id number(8) primary key,
tot_price float(8,2) default 0 not null,
currency_typ smallint not null --FK
)

create table CURRENCY (
currency_typ smallint primary key,
symbol varchar(5) not null,
disp_format varchar(20) not null
)

your php code can use CURRENCY.disp_format to display number properly.