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]

Re: Odd character appended to data

t8ntboy (t8ntboy@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, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[VIPS]

Re: Odd character appended to data

On Jul 2, 2:34 pm, Erland Sommarskog <esq...@sommars kog.sewrote:

t8ntboy (t8nt...@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, esq...@sommarsk og.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/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.