Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-28 : 09:30:56
|
| Carl Bentz writes "All was working well. Press releases were entered into an application that automatically took care of turning apostrophes into appropriate characters for SQL Server as well as Dahes and Double Quotes. Then, one of the network support staff decided to do some registry cleaning after a well known network monitoring application had gone amuck and inadvertently modified some registry keys that altered path statements among other things. Now it would appear that characters in the SQL tables have been altered. We find what appear to be opening single quotes (`) [I think it is actually the Grave accent U+0060 according to the Character Map, but I have not had a chance to view this information as straight data for sure. In the ASP pages, when the data is rendered into HTML some of the single quotes or apostrophes appear as square boxes, as do some Dashes and some Double Quotes. However, it is not consistent. I think that the problem is related to a missing reference to the 1033 locale environment information somewhere in the registry, but in comparing that server with others the gentleman did not touch, I haven't yet found an answer. I am thinking of performing some serious, painful surgery on this gentleman, but I would also like to know if there is someone in this group who might have a suggestion as to the registry key and its value that might resolve this problem. And tne next question, if a key was changed, would that have caused data in the tables to be altered. I don't think so. Thoughts? SQL Server 2000 standard ed no SP, on Windows 2000 Server SP1, IIS 5.0 and probably ASP 2.0" |
|
|
|
|
|
|
|
Character Rendering from SQL Server to ASP Pages