Hi everybody:

I am developing an application that uses SQLServer 2000 as its data
repository.

I have a varchar field in one of my tables, and when I do:

update PolicyInfo
set policyInfoName = N'ñ,á,é,æ,ä,å,û,ý,ß,?,?,?,?,?'
where id = 1

I got a policyInfoName  = ñ,á,é,æ,ä,å,û,ý,ß,ß,e,?,?,?
[notice the three last unmanaged Unicode characters)

Do I have to define something in my implementation, modify my connection
string or something like that [my connection language is English]?

Best regards,

Ernesto