Chinese Characters

[DaveRook]

Hi

I am using c# and MS SQL (express)

I have a simple web form where a user puts in their name and address and it updates straight to the SQL server. It also sends an email to let me know it's been updated, and the email contains the same information. This works very well.

The problem I have is if some one types anything in Chinese (traditional or simplified)!

The email I get is fine and displays Enligsh and Chinese, but it won't update my web form from the point of where the chinese characters were entered.

eg,

I have text boxes: First Name, Last Name, 1st Line Address and Country. If I write in English my first name but use Chinese on Last Name, and then English for Address and Country, the database will enter First Name but none of the rest. It seems it gets confused with the chinese characters and ignores everything as soon as it see's it!

I can only assume the chinese Characters make the server think their special characters and treating them like code?

Does any one have any ideas? My provider told me it was due to Access, which is why we have moved to SQL server!

Any ideas?

Thanks

[Frinavale]

Is it working with SQL Server?

[DaveRook]

No, sadly it is not working with SQL server.

[Denburt]

I did some digging and I'm not sure if I can be of much help but this should help point you in the right direction.

http://msdn.microsoft.com/en-us/library/system.text.encoding.aspx

[NeoPa]

This may seem to obvious, but you are using Unicode on whichever database you're using as a back-end yes?

[NeoPa]

If that is not relevant could you try posting some of your resolved SQL (that fails as you describe). Maybe there are characters in your SQL which resolve to special characters when treated as a non-Unicode string.