Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

After replacing ASCII interpretations of accentuated words in Postgresql tables these changes are not shown in my Django

I had names of cities in my DB that were shown like this ‘C & oacute;rdoba’ instead of Córdoba. This is, of course, because of the encoding. It is a very old table, maybe 20 years old, so probably before unicode UTF-8 was invented :))

So I changed all those escaping characters in the table with things like this:

SELECT nombre_localidad, 
replace(nombre_localidad,'ó','o')
FROM localidades 

as you can see, I removed the tilde so I left it as o instead of ‘ó’
which works well when I see it on my PGAdministrator viewer for the tables, but when I returned to my Django Application and I pulled the list of cities from my select lists, they are still showing the original thing, C & oacute;rdoba instead of Cordoba.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

Why is still Django picking the old data. Yes, I clicked on save data changes (F6) in my PgAdministrator

>Solution :

Have you tried to clean you cache?

python manage.py clear_cache

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading