Hi !

I have a problem with the representation of decimal fields.
My System is in English Language, i'm creating a database with the following configuration :
Database territory = FR
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 33
Database collating sequence = UNIQUE

Description of one table :
create table test (field1 decimal(5,3));
insert into test values (83.7);
and when i want to display the result of my insert, i have :
TEST
______
83,7

Can i have dot separator (.) instead of comma separator ( ?
Is it possible ?

Thanks in advance.

Lionel

Hi,
you can try "select char(field1) from test".
Hope this helps,
Grofaty

OK, thanks