Prev: Datetime import/export issue
Next: Using UPDATE to sequentially abbreviate address information
From: t8ntboy on 2 Jul 2008 11:01
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: Â

From: Erland Sommarskog on 2 Jul 2008 17:34
t8ntboy (t8ntboy(a)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(a)sommarskog.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
From: VIPS on 3 Jul 2008 13:46
On Jul 2, 2:34 pm, Erland Sommarskog <esq...(a)sommarskog.se> wrote:
> t8ntboy (t8nt...(a)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...(a)sommarskog.se
>
> 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.



 | 
Pages: 1
Prev: Datetime import/export issue
Next: Using UPDATE to sequentially abbreviate address information