[silva-dev] Special Characters in Content from MySQL Database

[Timo Schuerg]

> Hello!
> We're trying to move a Zope site to Silva. One of the pages aquires  
> its contents from a MySql Database. With plain Zope this page works  
> perfectly fine, all Umlauts and Special Characters get displayed  
> properly.
> If I try to do the same in the Silva framework I get the following  
> error message:
> 'ascii' codec can't decode byte 0xfc in position 11: ordinal not in  
> range(128)
> What confuses me: I only get this error message if I use
> folder/get_title_or_id
> to build my navigation bar. If I use
> folder/id
> the content from the SQL Method renders properly.
> I came up with the following workaround: Instead of using
> tal:content="publication/authors"
> I use
> tal:content="python:unicode(publication.authors,'Latin-1')"
> With this trick I don't get an error message anymore, but the  
> content still doesn't render correctly. All Umlauts get changed to  
> "?".
> Any Ideas?
> We use Zope 2.7.0 and Silva 1.1.
> Thanks a lot for your help
> Timo Schürg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.infrae.com/pipermail/silva-dev/attachments/20060616/3f0f23a7/attachment.htm