i have taken details view n fields can be viewed and updated....
when i click on Edit it allow to enter fields..
bt when i insert any symbols in textbox on updatation time it shows symbols bt after update then those symbols are converted to "?"
this way if i insert "(any symbol) helo" then after updating it shows "? helo"

Kirtan PatelPosted Feb 26, 2010, 8:57 AM
You need to Use nvarchar data type in database Column where you are Storing Symbol + Text Data..for displaying them..
I included Sample Project ..Just Take a Look :)
Happy Coding :)
ans please check "do you like this answer" check box :)
Kirtan PatelPosted Feb 26, 2010, 11:47 AM
Dipa AhujaPosted Feb 26, 2010, 11:23 AM
i mean though i press enter n write text in new line bt it just ignore it n show text as it is
Dipa AhujaPosted Feb 26, 2010, 9:36 AM
viral UpadhyayPosted Feb 26, 2010, 8:38 AM
Dipa AhujaPosted Feb 26, 2010, 4:53 AM
hi.. i want that textbox should display symbol..
i have taken details view n it allow editing:
see the edit mode:
now when i click on update...
i want that it should display symbols...
Sam HobbsPosted Feb 23, 2010, 12:13 PM
I am not an expert with SQL Server, but the problem is likely the codepage, or something such as that. SQL Server is probably not set up for Unicode for the database or table or the field. If Unicode is not used then we must use a codepage that supports the characters we need. If Unicode is used then codepages do not apply.