Hi again list

After have setup my zope site and database to use ISO-8859-1, I did some test and unfortunely it fail with javascript doing AJAX calls because the standart says that all calls must be UTF8 nevertheless the chatset in the page.

So now I'm changing to use UTF8, but I have another problems: the data is stored in incorrect way.
I tried to save "test áñ" but it's stored "test áñ"

My setup
-Windows 7
-Zope 2.13.23
-MS Sql server 2008


--zope.conf
rest-input-encoding utf-8
rest-output-encoding utf-8
default-zpublisher-encoding utf-8

--python file site.py
encoding = "utf-8"

--html header
<meta http-equiv="content-type" content="text/html; charset=utf-8">


The pages
* index_html (dtml-document)
containt the html FORM

*estado.html ( dtml-method)
according to a field from the FORM, it call differents pages, in this case to "agregar.html"

* agregar.html (dtml-document)
recive the data and call the Zsql (agrega_credencial)

* agrega_credencial (zsql method)
 "insert into credencial (nombre) values ( N'<dtml-sqlvar credencial type="nb">')"

--MS SQL Server
the fields are nvarchar

--SQL Server management (admin tool)
here is were I see that the data is stored like "test áñ",


but even if I use the agrega_credencial (zsql method) using the ZMI the data is not saved correctly.

What do I need to use UTF8 in my setup? What I'm missing?


 
________________________________________
Lo bueno de vivir un dia mas
es saber que nos queda un dia menos de vida