Hi Iain,

On Mon, Feb 25, 2008 at 9:03 PM, iain duncan <[EMAIL PROTECTED]> wrote:
>
>  Hi folks, I recently did a major upgrade on a site and moved it to a vps
>  that I'm maintaining, and now I seem to have lost all ability to enter
>  unicode.
>

Do the difficulties occur only with the old data or do you see the
same behaviour if you bootstrap a clean database and run from that?

Your UnicodeDecodeError looks hauntingly familiar and it was caused by
corrupted data in the database.  I suspect that by changing the
encoding with existing data will have caused problems.  I assume that
you have a backup of your database from before you made these changes?

I have a script that uses SA to go through every row of every table
and fixes encoding issues, but it's fairly dangerous in that it hasn't
been widely tested and could break your data further.  I will send it
along privately as it really isn't fit for public consumption and you
can test it on a backup of your database to see if it solves your
issues.

Lee



-- 
Lee McFadden

blog: http://www.splee.co.uk
work: http://fireflisystems.com
skype: fireflisystems

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to