I have a text box that my user creates headlines for articles with. He copies and pastes from Word. I place the headline in both a text file and in the database. He uses characters like ‘ “” ‘’ (windows-1252 characters) they store to the text
file fine as I using ISO-8859-1 encoding. But when I use a store procedure using a sqlcommand in C# they store as '?'. Now when I go to the database directly and use management studio and execute the store procedure it stores just fine. What is up?? I
am losing hair over this problem. I know I can do a replace in C# but it seems like I shouldn't have to.
dmasterson
0 Points
1 Post
Problem with stored procedures and windows-1252 encoding
Nov 30, 2012 04:11 PM|LINK
I have a text box that my user creates headlines for articles with. He copies and pastes from Word. I place the headline in both a text file and in the database. He uses characters like ‘ “” ‘’ (windows-1252 characters) they store to the text file fine as I using ISO-8859-1 encoding. But when I use a store procedure using a sqlcommand in C# they store as '?'. Now when I go to the database directly and use management studio and execute the store procedure it stores just fine. What is up?? I am losing hair over this problem. I know I can do a replace in C# but it seems like I shouldn't have to.
Catherine Sh...
All-Star
23382 Points
2490 Posts
Microsoft
Re: Problem with stored procedures and windows-1252 encoding
Dec 07, 2012 01:22 AM|LINK
Hi,
Welcome to ASP.net forum!
In order to resolve your issue, please share the corresponding code which wil help us continue.
Best wishes,
Feedback to us
Develop and promote your apps in Windows Store