odoo 17 setup encoding error

Question

I am trying to get the odoo local host server to work. i am getting the error as*: UnicodeDecodeError: 'utf-8' codec can't decode byte 0xfc in position 97: invalid start byte.*
The pre installations are already done the postgres, pgadmin, newest python version. i am using pycharm in windows. i think the erros is due to the psycopg2 wiht the postgres server. any one had the same issue??

Abdou Belhadj · Accepted Answer

I'm pretty sure the issue is due to the browser cache. Try opening it in a private/incognito window to confirm.

mer5 · Answer

i think the issue in the postgres user try to alter role utf8 to user by the below (run it from psql shell)
ALTER ROLE user SET client_encoding TO 'utf8';
change user with your postgres user

Cesar García · Answer

I'm setting up odoo 18 on localhost and I encountered this error. Your solution worked very well for me. Thank you!

Friedrich Sauer · Answer

There was no easy fix. It seems that running the odoo server locally in windows is a huge gamble, dependency-version-wise.

Therefore I am using wsl now at the tradeoff of slightly worse PyCharm integration.
This Video was great help:  https://www.youtube.com/watch?v=4wpaTRaOwJo [1]

Best

[1] https://www.youtube.com/watch?v=4wpaTRaOwJo

Related Posts	Replies	Views
In Failed SQL Transaction postgresql psycopg2	1 सित॰ 21	5187
Error at connect to an external postgres postgresql psycopg2 OdooSH	1 जुल॰ 25	2399
while creating database aws ubuntu server odoo17 database postgresql v17	1 जून 24	2875
PostgreSQL port do not match psycopg2 default port Solved postgresql port psycopg2	2 अप्रैल 24	11571
Following the Odoo 17 installation guide when I run the command sudo -u postgres createuser -d -R -S $USER I get the message could not change directory to "/home/odoo": Access denied installation postgresql v17 ubuntu22.04	0 जन॰ 24	3258

This question has been flagged

Enjoying the discussion? Don't just read, join in!