[egenix-users] Unicode problems with mxODBCZopeDA-1.0.10

[Jose Rivera Merla]

*I am having problems displaying spanish accents like á,é,í,ó and ú.

My setup is:*

   - Plone 3.0.3
   - CMF-2.1.0
   - Zope (Zope 2.10.5-final, python 2.4.4, win32)
   - Python 2.4.4 (#71, Oct 18 2006, 08:34:43) [MSC v.1310 32 bit
   (Intel)]
   - PIL 1.1.6

*and mxodbc:*
mxODBCZopeDA (Installed product mxODBCZopeDA
(mxODBCZopeDA-1.0.10))<http://fctcmty01:8080/Control_Panel/Products/mxODBCZopeDA/manage_workspace>


*With the following string returned from a database I get a problem:*

'XX a\xe1 e\xe9 i\xed o\xf3 u\xfa A\xc1 E\xc9 I\xcd O\xd3 U\xda n\xf1 N\xd1'

*When I try to display it it doesn't  display correctly, I made an
experiment with the same value in a python script and it worked after I
returned the following script*

u'XX a\xe1 e\xe9 i\xed o\xf3 u\xfa A\xc1 E\xc9 I\xcd O\xd3 U\xda n\xf1
N\xd1'

*instead of just*

'XX a\xe1 e\xe9 i\xed o\xf3 u\xfa A\xc1 E\xc9 I\xcd O\xd3 U\xda n\xf1 N\xd1'

*How can I make it work?

Regards,
Jose
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: /mailman-archives/egenix-users/attachments/20071126/9cf50d2b/attachment.htm