problem with non-english characters in MS SQL 2005

Hello

I have problem inserting non-english characters into MS SQL 2005 database. My page with form that collect data is UTF-8. When I try to insert characters like čć they are stored in my MS SQL database like cc, but characters like šž are ok.

My database fields are nvarchar type. I really cant find solution to this.

What is the problem, and how to solve it ?

Thank you in advance.

Well i am not having problem with my copy of WWF, i am building application of my own.

I could change collation to Croatian, but I am building an international application where it could be used croatian, french, italian or russian character so I need some solution to my database that will accept all the characters.

Edited by tjodalv - 27 April 2009 at 6:57pm