Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    5

    Unanswered: Pb with comma separator in decimal fields

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    you can try "select char(field1) from test".
    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Oct 2006
    Posts
    5
    OK, thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •