#35268: Migrations raise UnicodeDecodeError on PostgreSQL.
-------------------------------------+-------------------------------------
Reporter: Azim1900 | Owner: nobody
Type: Uncategorized | Status: closed
Component: Database layer | Version: 5.0
(models, ORM) |
Severity: Normal | Resolution: needsinfo
Keywords: PostgreSQL | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):
* component: Uncategorized => Database layer (models, ORM)
* resolution: => needsinfo
* status: new => closed
* summary:
Error in Django Migration in PostgreSQL : UnicodeDecodeError during
'python manage.py migrate'
=> Migrations raise UnicodeDecodeError on PostgreSQL.
Old description:
> When running the command 'python manage.py migrate' in a Django project,
> a UnicodeDecodeError occurs during the migration process.
>
> The error trace indicates that the issue is related to decoding a byte
> (0xbb) at position 79, and the problematic code is within the PostgreSQL
> database backend connection setup. The error originates from the
> 'psycopg2' library, and the specific context points to a Unicode decoding
> problem in the 'data_handler.py' file. The error disrupts the migration
> process and prevents the successful execution of the command.
>
> Here is also Database Setting in my Django Project :
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.db.backends.postgresql',
> 'NAME': 'Databank',
> 'USER': 'user',
> 'PASSWORD': '123456',
> 'HOST': 'localhost',
> 'PORT': '5432',
> 'OPTIONS': {
> 'client_encoding': 'UTF8',
> }
> }
> }
New description:
When running the command 'python manage.py migrate' in a Django project, a
UnicodeDecodeError occurs during the migration process.
The error trace indicates that the issue is related to decoding a byte
(0xbb) at position 79, and the problematic code is within the PostgreSQL
database backend connection setup. The error originates from the
'psycopg2' library, and the specific context points to a Unicode decoding
problem in the 'data_handler.py' file. The error disrupts the migration
process and prevents the successful execution of the command.
Here is also Database Setting in my Django Project :
{{{
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql',
'NAME': 'Databank',
'USER': 'user',
'PASSWORD': '123456',
'HOST': 'localhost',
'PORT': '5432',
'OPTIONS': {
'client_encoding': 'UTF8',
}
}
}
}}}
--
Comment:
Hi, I don't think you've explained the issue in enough detail to confirm a
bug in Django. Please reopen the ticket if you can debug your issue and
provide details about why and where Django is at fault (or a sample
project that reproduced the issue). If you're having trouble understanding
how Django works, see TicketClosingReasons/UseSupportChannels for ways to
get help.
--
Ticket URL: <https://code.djangoproject.com/ticket/35268#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018e0922a434-f3044897-9c78-4a46-9dec-22f702d6f793-000000%40eu-central-1.amazonses.com.
