I'm fairly new to developing in Visual Studio and have run into a problem using DetailsView writing text to SQL Server 2005.
When editing text and saving, characters like ö (o with umlaut) are changed. The character ö becomes ö in the database and when read back into DetailsView.
If I use SQL Server Management Studio to write the character into the database field it is not changed, i.e. it is correct also when read into the DetailsView control. My problem only occurs when saving from the DetailsView control.
I'm sure there's a simple solution to this but I'm stuck, so any help would be greatly appreciated. Thanks!