On Dec 22, 9:14 pm, Ana <adles...@gmail.com> wrote:
> Hello,
>
> I migrated my MySQL tables to Postgres. Generally, the migration was
> fine with one exception. I have a table researchproj that included
> two foreign keys (institution_id and contact_id). I received the
> following error:
>
> Caught an exception while rendering: ('ascii', u'Jorge Gir\xf3n', 9,
> 10, 'ordinal not in range(128)')
>
> when I tried to access the researchproj table through admin. If I
> delete the column contact_id, the error goes away. If I add the
> column back onto the table the error returns. All the tables contain
> data, although I created a test researchproj table with just one
> tuple. I've added, deleted and done acrobats trying to get the admin
> to accept the column contact_id in the researchproj table. I have
> checked the sequence numbers for all tables, and also any referential
> integrity issues with all the tables. Can someone help?
>
> Thanks,
>
> Ana
This is not a data integrity issue, but a character set one. The
character represented by the unicode sequence \xf3 (an o with an acute
accent, I think) cannot be converted into valid ASCII. You should
probably be using UTF-8 as the character encoding of your tables.
--
DR.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
