Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQLXML / IIS 5.0 / UTF-8

Author  Topic 

martin.bory
Starting Member

1 Post

Posted - 2004-03-06 : 09:10:10
Hi,

I have following problem. I have a HTML (UTF-8 encoded) page with a form on it. The form POSTs data to a SQLXML template (UTF-8 encoded) through IIS 5.0 (and SQLXML 3.0 SP2 connector) and the template is to INSERT or UPDATE data in the database. The fields for those data are either ntext or nvarchar. The thing is the 2byte characters are stored as 2 characters (it seems like I can't pass UTF-8 string through the <sql:param>. Have anyone ever played with this ? passing UTF-8 data through a template to MS SQL Server and get it right ?

Thanks for help

Martin
   

- Advertisement -