Question 22164 in Mysql Question posted in
The official MySQL documentation can be found here.

display commas instead of periods – Mysql

in my sql table I have decimal data with dot as a separator but the display in my page is done with commas

I would like to display them with dot

in my settings i have this

LANGUAGE_CODE = "fr-fr"

TIME_ZONE = "UTC"

USE_I18N = True

USE_TZ = True

my models

class VilleStation(models.Model):
    nomVille = models.CharField(max_length=255)
    adresse = models.CharField(max_length=255)
    cp = models.CharField(max_length=5)
    latitude = models.DecimalField(max_digits=9, decimal_places=6)
    longitude = models.DecimalField(max_digits=9, decimal_places=6)

in the templates i have this

{% for c in object_list %}                
{{c.nomVille}}
{{c.adresse}}
{{c.cp}}
{{c.latitude}}
{{c.longitude}}
{% endfor %}

thank

Tags:

2

Answers


  1. 0

    Decimal separator is controlled by two settings in Django settings:

    First one is DECIMAL_SEPARATOR (Default: ‘.’)

    https://docs.djangoproject.com/en/4.1/ref/settings/#decimal-separator

    And second one: USE_L10N (Default: True)

    https://docs.djangoproject.com/en/4.1/ref/settings/#use-l10n

    in your case use USE_L10N=False

    Login or Signup to reply.
  2. 0

    Give this a whirl, as per the docs, you can turn off number localisation like so:

    {{  value|floatformat:"3u"  }}

    What do the docs say?

    Output is always localized (independently of the {% localize off %} tag) unless the argument passed to floatformat has the u suffix, which will force disabling localization.

    Be aware of the following note further down the page:

    Changed in Django 4.0:
    floatformat template filter no longer depends on the USE_L10N setting and always returns localized output.

    And subsequently:

    The u suffix to force disabling localization was added

    Please see the documentation regarding the floatformat template tag

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search