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 |
|
charford
Starting Member
8 Posts |
 Posted - 2007-09-17 : 08:42:35
|
| I'm getting some odd intermittant missing character problems when displaying text from a 'text' column. The text is in plain English with no unusual or non alphanumeric characters. Every so often the text is displayed with a character missing somewhere in the middle of the text. I have tried to look at what is stored in the database but cannot seem to view the contents of the 'text' column using Enterprise Manager.The following extract shows two lines of text which are list items (<ul>). The second line shows a lowercase 't' missing on the word dedicated. This line was copied from the first. Sometimes it displayes correctly and at other times the 't' is missing.EXAMPLE:The only dedicated wine travel website with producer recommendations from a team of well known wine writing experts. The only dedicaed wine travel website with independent recommendations of places to stay and eat.This is doing my head in as I can find NO logical reason for it.If anyone has any clues as to where I should be looking for some answers I would be delighted to know. Thanks.Charles H. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-09-17 : 08:46:06
|
| Use Query Analyzer, be sure that "Results to Text" is selected, and then select those values from the table and see how they look.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
charford
Starting Member
8 Posts |
Posted - 2007-09-17 : 09:45:20
|
| Hi, thanks for the suggestion. I tried this too but it trucates the text after the first 256 characters. (sounds like some sort of 8 bit thingy going on there). The text is all one one huge long line. I wonder if this is causing problems?.The text is being entered by my client using an online HTML editor called XStandard. This seems to take whatever you type, no matter how many lines and turn it all into one long string with no VbCrLf. |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-09-17 : 09:55:20
|
| Go in rhru Query\Query Options\ Results\Text and increase them maximum number of characters displayed in each column.I don' think that will solve the missing "t", that sounds like a typo in the original data.Jim |
|
|
|
charford
Starting Member
8 Posts |
Posted - 2007-09-17 : 10:54:06
|
| Hi jimf. Thanks for your tip. I was able to see all the content by increasing the max like you suggested. The missing "t" is clearly there and no suspicious looking characters around it. Just plain old text. I also thought about the typo, but my client swears the "t" has been there all along. Also the missing "t" is intermittant. Sometimes all the text displays correctly, sometimes it doesn't. Apparently this is happening in other areas on the system, with text from different tables.Do you think I should try a different data type than 'text'? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-09-17 : 11:07:27
|
| Some non-printable characters may cause "issues"....ie where the hex values of a character do not map to a visible character...Ive seen this outside of SQL...You could inspect the input/output streams using some kind of hex editor to prove/track things down. |
|
|
|
charford
Starting Member
8 Posts |
Posted - 2007-09-17 : 11:46:35
|
| Thanks, I'll look into that (I've no idea how yet). |
|
|
|
|
|
|
Intermittant missing characters