ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> zope-list
zope-list
[Zope] UTF-8 problem with zope2.10 and postgresql
by Claire Boussard other posts by this author
Nov 6 2009 8:40AM messages near this date
Re: [Zope] UTF-8 problem with zope2.10 and postgresql [Solved] | Re: [Zope] UTF-8 problem with zope2.10 and postgresql
Hello,

I'm trying to upgrade my applications from debian sarge
to debian lenny, so from zope2.7 to zope2.10.

I've decided to have all in UTF-8 in my new server,
which is the default for lenny, for postgresql also.

The situation now is :
In the database, all is OK
If I create a ZSQL method (say sql_candidat) in the ZMI and test it, all
is OK (example firstname : Andrée)
If I create a dtml method, loop over my ZSQL method, and print
the firstname, it's messed up.

Example dtml:
<dtml-in sql_candidat> 
  <dtml-var firstname> 
</dtml-in> 

The result in the browser is : Andrée

A contrario :
In the page
<input type="text" size="20" name="firstname:utf8:ustring"
In the browser, I type Andrée, I click on submit, the data are saved through
another ZSQL method (UPDATE SQl statement) and all is OK in
the database

In zope.conf:
locale fr_FR.utf8
rest-input-encoding utf-8
rest-output-encoding utf-8
rest-language-code fr
default-zpublisher-encoding utf-8

In the HTML page 
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> 

The HTTP header (with liveHTTPheader in firefox) is correct :
Content-Type: text/html; charset=utf-8


Any idea ?

Claire Boussard.
_______________________________________________
Zope maillist  -  Zope@[...].org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )
Thread:
Claire Boussard
Andreas Jung
Jonathan
Andrew Milton
Andreas Jung
Andrew Milton
Garry Saddington
Martijn Pieters
Andrew Milton
Tres Seaver
Andrew Milton
Martijn Pieters
Andreas Jung
Allen Schmidt Sr.
Andreas Jung
Chris Withers
Garry Saddington

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved