Hi,
I'm having a problem with to_char() inserting unexpected characters as group
separator.
For the record below, I wish to display 'credit' properly formated in an html
form, using to_char(credit, 'FM999G990D00')
SELECT *, to_char(credit, 'FM999G990D00') as yo from tblprospect_balance where
id_item = 33;
id_prospect | id_item | date_item | libelle | debit | credit | lettrage |
id_facture | yo
-------------+---------+------------+---------+-------+---------+----------+------------+----------
385 | 33 | 2021-03-09 | yo man | 0.00 | 2345.10 | |
8 | 2 345,10
The numbers are properly displayed in the html form. However, updating the
record requires the user to manually delete the space in '2 345,10', otherwise
the last digit is lost. Typing numbers including a group separator using the
space bar works fine.
I exported the record to a text file and inspected it with emacs in hexadecimal
mode :
3338 3509 3333 0932 3032 312d 3033 2d30 385.33.2021-03-0
00000010: 3909 796f 206d 616e 0930 2e30 3009 3233 9.yo man.0.00.23
00000020: 3435 2e31 3009 0938 0932 e280 af33 3435 45.10..8.2...345
00000030: 2c31 300a ,10.
As you can see, the space in field 'libelle' (yo man) is different from the one
in field 'yo' (2...345,10)
The difference is also apparent in a link built using the record's fields as
parameters :
/base/prospect?id_prospect=385&balance=0&update_item=0&id_item=33&id_facture=8&date_item=2021-03-09&libelle=yo%20man&debit=0,00&credit=2%E2%80%AF345%2C10&lettrage=
^^^^^^^^^^^^^ ^^^^^^^^^^^^
What can I do to get a standard space as group separator for my numbers?
#### system information ########
I use postgresql 11.9 on Debian buster
My settings are :
show lc_numeric;
lc_numeric
-------------
fr_FR.UTF-8
locale
LANG=C.UTF-8
LANGUAGE=
LC_CTYPE="C.UTF-8"
LC_NUMERIC="C.UTF-8"
LC_TIME="C.UTF-8"
LC_COLLATE="C.UTF-8"
LC_MONETARY="C.UTF-8"
LC_MESSAGES="C.UTF-8"
LC_PAPER="C.UTF-8"
LC_NAME="C.UTF-8"
LC_ADDRESS="C.UTF-8"
LC_TELEPHONE="C.UTF-8"
LC_MEASUREMENT="C.UTF-8"
LC_IDENTIFICATION="C.UTF-8"
LC_ALL=
\d tblprospect_balance
Table "public.tblprospect_balance"
Column | Type | Collation | Nullable |
Default
-------------+---------------+-----------+----------+------------------------------------------------------
id_prospect | integer | | not null |
id_item | integer | | not null |
nextval('tblprospect_balance_id_item_seq'::regclass)
date_item | date | | not null | CURRENT_DATE
libelle | text | | |
debit | numeric(10,2) | | not null | 0
credit | numeric(10,2) | | not null | 0
lettrage | text | | |
id_facture | integer | | not null | 0
--
Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de gestion des sinistres assurances, des dossiers contentieux et des
contrats pour le service juridique
