RE: traping curly apostrophes

Hi Ryan,

Thank you for posting here.

From your description, I understand that in one of your ASP.NET web page,
the user will input some text data and submit them to store in the
database, and these data will be displayed again on the webform later.
However, you found that there are some particular characters which will be
displayed as "????" after retrieved from database and display them again,
correct?

Based on my experience, this is likely a charset conversion issue, and "?"
sign indicates that the charset used in the conversion can not identify the
original character , so it use "?" to replace it. Generally for such issue,
there are three steps to can troubleshoot and isolate on this issue:

1. Check in the database after the user input has been stored in database.
This helps ensure whether the characters remain correct in the database
(from the input page).

2. In the display page, you can set breakpoint in the page code and lookup
the string data retrieved from database to see whether the text got from
database is still the correct characters.

3. Finally, even if the data in ASP.NET page's runtime memory(as Unicode
chars) is correct, after the page resposne encoding the data and flush out,
the charset of the response should match the client browser's encoding
setting, otherwise, the browser still can not correctly display these chars.

You can trace the text through the above ways. If you feel anything unclear
or meet any further dificulties, please feel free to post here.

Regards,

Steven Cheng
Microsoft MSDN Online Support Lead


==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================


This posting is provided "AS IS" with no warranties, and confers no rights.



Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)









.

Relevant Pages

  • RE: Userform to add and update a table
    ... One of the most common scenarios in application development is to display ... the walkthrough illustrates many of the basic ... Access to a server with the Pubs SQL Server sample database. ... Creating the Windows Form. ...
    (microsoft.public.sqlserver.programming)
  • Re: Picture property for Access 2K forms
    ... and it works great...until you look at the database size involved. ... or by simply scaling down the image display in the ... > supported by those filters. ... To associate a graphic file with an OLE Server, ...
    (microsoft.public.access.devtoolkits)
  • Re: Is there a character limit on bound controls?
    ... doesn't mean they all went into the database. ... just fine - I've put more than 1,000 characters in without incident. ... However, on the page that needs to display the text, the text is ... The truncation happens regardless of whether there ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Unknown Maiden Name [WAS how-to ruin a perfectly good FGS]
    ... through at the beginning of my database, ... or display your information in the fields you intended for them. ... the names in a manner you didn't intend and the meaning has become ... If my data is on the Internet and people don't understand it, ...
    (soc.genealogy.methods)
  • Re: webviewer background image from filemaker container field
    ... It is not elegant or simple the moment you factor in how a webviewer ... passes the result back to FM to display. ... info out of the schema of the database. ... And the quality of advice in books and formal filemaker education is ...
    (comp.databases.filemaker)