Skip to Content
Menú
This question has been flagged
2 Respostes
8698 Vistes

Database creation error: encoding "UTF8" does not match locale "en_US" DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1".

 
i'm facing the problem when  create database using odoo13  

it works fine with odoo10 

Avatar
Descartar

Please use a meaningful title next time and provide the necessary information.

Best Answer

1- Uninstall postgres using:

sudo apt-get --purge remove postgresql postgresql-*
dpkg -l | grep postgres
sudo apt-get --purge remove postgresql postgresql-doc postgresql-common


2- change locales/rebooted before running salt

sudo update-locale LANG=en_US.utf8

sudo update-locale LANGUAGE=en_US.utf8 

reboot

3- reinstall sql and create user using:

sudo apt install postgresql



sudo su - postgres -c "createuser -s odoo"
Avatar
Descartar
Best Answer

Hi Mostafa:

Looks like the system locale has not been configured for UTF-8. The following link provides instructions on how to configure the system locale on Debian 9. You will need to do something similar based on the operating system of your server.

https://www.rosehosting.com/blog/configure-system-locale-on-debian-9/

Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
de febr. 24
1640
2
de març 24
5532
1
de febr. 24
2724
0
d’ag. 21
2673
0
d’ag. 21
2744