Odd character appended to data

[t8ntboy]

The following character keeps appending itself to data inserted
through a web form. What is it from (how is it generated) and how can
it be removed? Here it is: Â

[Erland Sommarskog]

t8ntboy (t8*****@gmail.com) writes:

The following character keeps appending itself to data inserted
through a web form. What is it from (how is it generated) and how can
it be removed? Here it is: Â

There is not enough information in your post to even make it guess where
it comes from. In any case, I would suspect that this is related to the
web software or the client API and not SQL Server.

You can remove it with:

UPDATE tbl
SET col = substring(col, 1, len(col) - 1)
WHERE col like '%Â'
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[VIPS]

On Jul 2, 2:34*pm, Erland Sommarskog <[e-mail]:

t8ntboy ([e-mail]) writes:

The following character keeps appending itself to data inserted
through a web form. *What is it from (how is it generated) and how can
it be removed? * *Here it is: *Â

There is not enough information in your post to even make it guess where
it comes from. In any case, I would suspect that this is related to the
web software or the client API and not SQL Server.

You can remove it with:

* UPDATE tbl
* SET * *col = substring(col, 1, len(col) - 1)
* WHERE *col like '%Â'

--
Erland Sommarskog, SQL Server MVP, [e-mail]

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

The way to see if SQL Server itself is generating this( which is
highly doubted under any /sp/build/QFE ) is to install client tool
and use query analyzer and update a row using another client machine
or from the application server.
If char is not present, then the application's parser or delimitor
functionality or the IOstream needs to be examined.