#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 django-updates+unsubscr...@googlegroups.com.
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.
