Error with a postgres DB with special characters #1018
Description
It's not clear from where the character 0xe9 (é) is coming. Its nor in a schema name, database name or in a role. Similar error appears in the log when listing the available schemas.
The database is configured with a french locale, and is working fine on QGIS without using model baker.
Une erreur est survenue lors de l'exécution du code Python :
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe9 in position 114: invalid continuation byte
Traceback (most recent call last):
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\gui\workflow_wizard\database_selection_page.py", line 181, in nextId
return self.workflow_wizard.next_id()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\gui\workflow_wizard\workflow_wizard.py", line 240, in next_id
self._update_configurations(self.import_database_selection_page)
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\gui\workflow_wizard\workflow_wizard.py", line 510, in _update_configurations
page.update_configuration(self.import_schema_configuration)
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\gui\workflow_wizard\database_selection_page.py", line 129, in update_configuration
configuration.db_ili_version = db_utils.db_ili_version(configuration)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\libs\modelbaker\utils\db_utils.py", line 151, in db_ili_version
db_connector = get_db_connector(configuration)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\libs\modelbaker\utils\db_utils.py", line 127, in get_db_connector
return db_factory.get_db_connector(uri_string, schema)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\libs\modelbaker\db_factory\pg_factory.py", line 36, in get_db_connector
return PGConnector(uri, schema)
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins\QgisModelBaker\libs\modelbaker\dbconnector\pg_connector.py", line 44, in __init__
self.conn = psycopg2.connect(uri)
^^^^^^^^^^^^^^^^^^^^^
File "C:\PROGRA~1\QGIS34~1.4\apps\Python312\Lib\site-packages\psycopg2\__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe9 in position 114: invalid continuation byte
Version de Python : 3.12.9 (main, Feb 7 2025, 14:34:44) [MSC v.1938 64 bit (AMD64)]
Version de QGIS : 3.40.4-Bratislava Bratislava, 4dd7d7e969
Chemin Python :
C:/PROGRA~1/QGIS34~1.4/apps/qgis-ltr/./python
C:/Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python
C:/Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python/plugins
C:/PROGRA~1/QGIS34~1.4/apps/qgis-ltr/./python/plugins
C:\PROGRA~1\QGIS34~1.4\apps\grass\grass84\etc\python
C:\Program Files\QGIS 3.40.4\bin
C:\Program Files\QGIS 3.40.4\bin\python312.zip
C:\PROGRA~1\QGIS34~1.4\apps\Python312\DLLs
C:\PROGRA~1\QGIS34~1.4\apps\Python312\Lib
C:\PROGRA~1\QGIS34~1.4\apps\Python312
C:\PROGRA~1\QGIS34~1.4\apps\Python312\Lib\site-packages
C:\PROGRA~1\QGIS34~1.4\apps\Python312\Lib\site-packages\win32
C:\PROGRA~1\QGIS34~1.4\apps\Python312\Lib\site-packages\win32\lib
C:\PROGRA~1\QGIS34~1.4\apps\Python312\Lib\site-packages\Pythonwin
C:/Users/hvg/AppData/Roaming/QGIS/QGIS3\profiles\HVG_modelBaker/python