On Thu, Sep 3, 2009 at 12:03 PM, Mike<[email protected]> wrote: > > Hi All; > > I have an application that retrieves information from a web feed and > inserts into a database for other processing. the issue i am > encountering is when i try to insert a string value that has special > characters such as the trade mark symbol, copy right, registered, > degree etc... > > i have tried using the string replace using the equivalent ascii code > for the proper symbol but i am not having any luck. > > this is not a web application so i can not use the server.encode to > get strip the values. > > this is what i tried without success: > > descripition = description.replace("™"," "); > > to try and remove the trademark symbol... > > thanks > - Mike >
ack! no! no! what character set are you dealing with? probably utf-8 on the web side. what character encoding is the DB set up for? check out the ASCIIEncoding namespace. ∞ Andy Badera ∞ +1 518-641-1280 ∞ This email is: [ ] bloggable [x] ask first [ ] private ∞ Google me: http://www.google.com/search?q=(andrew+badera)+OR+(andy+badera)
