Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Accented or special characters issue #30

Open
ScarlitoDoBrazil opened this issue Nov 28, 2024 · 0 comments
Open

Accented or special characters issue #30

ScarlitoDoBrazil opened this issue Nov 28, 2024 · 0 comments

Comments

@ScarlitoDoBrazil
Copy link

Hi everyone.

I'm doing a clean install. I tried several options, but none of them fixed the issue.
I tried several character sets and collations for the MariaDB database, but still no luck.
Here is an example of what I get in the DB right after the installation. In the "llx_c_country" for example I get "Côte d'Ivoire" instead of "Côte d'Ivoire". And same goes for any special or accented character as you can see in the following screenshot :

image

Here is my compose file :

networks:
  internal-pod:
    internal: true
  external-pod:
    internal: false

volumes:
  doli-docs:
  doli-custom:
  doli-db:

services:
  dolibarr:
    image: dolibarr/dolibarr:latest
    environment:
      DOLI_DB_HOST: "mariadb"
      DOLI_DB_HOST_PORT: "3306"
      DOLI_DB_USER: "dbuser"
      DOLI_DB_PASSWORD: "dbpassword"
      DOLI_DB_NAME: "dbname"
      DOLI_ADMIN_LOGIN: "admin"
      DOLI_ADMIN_PASSWORD: "adminpassword"
      DOLI_COMPANY_COUNTRYCODE: "FR"
      DOLI_COMPANY_NAME: "MyCompany"
      PHP_INI_DATE_TIMEZONE: 'Europe/Paris'
    ports:
      - 80:80
    volumes:
      - doli-docs:/var/www/documents
      - doli-custom:/var/www/html/custom
    networks:
      - internal-pod
      - external-pod

  mariadb:
    image: mariadb:latest
    command: ['--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci']
    environment:
      MYSQL_DATABASE: "dbname"
      MYSQL_USER: "dbuser"
      MYSQL_PASSWORD: "dbpassword"
      MYSQL_ROOT_PASSWORD: "dbrootpassword"
    volumes:
      - doli-db:/var/lib/mysql
    networks:
      - internal-pod

  adminer:
    image: adminer
    depends_on:
      - mariadb
    restart: unless-stopped
    ports:
      - 8080:8080
    networks:
      - internal-pod
      - external-pod

I tried without the "command" under mariadb, and also with utf8mb4_general_ci, but with no success.
As you can see, all the tables are set to the supposedly good collation :

image

Of course, each time I was starting from scratch (cleaning the volumes, etc.).
I tried on Docker Desktop and also on Container Manager on my Synology NAS. Same result each time.

Any idea ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant