JimmyCrackedCorn
Posts: 583
|
| Posted: 08/28/2007, 3:44 PM |
|
I just noticed when using the search feature generated by CCS, some of my searchs using a term that includes an apostrophe do not return values even though I know the value (with apostrophe) is in the database.
When I looked closer I found that some of the values in the database had been copy/pasted from Word rather than being typed into my application. When typed in, the ASCII 27 character for apostrophe is used but when pasted from Word the ASCII 92 character for the prettier apostrophe is used.
Has anyone run into this and resolved it? I guess I'll just check the submitted values before they go into the database and convert ASCII 92 to ASCII 27 in all cases.
1) anyone have a better idea?
2) any other character situations like this I should be aware of?
_________________
Walter Kempees...you are dearly missed. |
