[egenix-users] UTF-8 problem

[Martin Winkler]

Hi all,

we are using mxODBC Zope DA 1.0.9 on a RedHat 9 server that connects via
iodbc to an Intersystems Cach´e database.

trying to submit a form that inserts a new record like:

insert into tablename (title) values ('täst'), the command executes
fine. (the form is utf-8 encoded)

when displaying a select query in a page template, the "ä" transforms
into something strange:

tal:content="item/title" 
and
tal:content="python:unicode(item['title'],'utf-8')"

shows "tXYst"

X stands for an 'A' with a "^" above
Y stands for a symbol that looks like an "x" overlaid by a disc

I also tried 

tal:content="python:unicode(item['title'],'utf-8').encode('utf-8')"

but this returns the even more weird result "tXYZAst"
X = A with ~
Y = a simple square
Z = A with ^
A = the "x" overlaid by a disc

Anybody can help me with this?

Regards

Martin