=?Utf-8?Q?ASP_VBScript_insert_/_Update_and?=

TheMSsForum.com: The Microsoft Software Forum

Hi guys,

Your expertise would be so appreciated on this one, I'm using CS3 and MS SQL
server,

There is a field where a user may need to enter the pound sign, for instance
"£24,000 per annum plus benefits" etc

The problem is that somewhere during the insert update it changes the £
pound sign to either a #hash or it inserts the value without the £pound
sign...

The page lauguage is -

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

the details in the head section are

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script type="text/javascript" src="../Scripts/currentdate.js"></script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

The SQL Collation is SQL_Latin1_General_CP1_CI_AS

I'm kind of at a loss as to what the problem is with the £ pound sign??

Is there maybe a way or catching and changing the £ sign before insert or
update??

PLEASE -- PLEASE help

thanks
Top

Re: ASP VBScript insert / Update and £ sign by Anthony

Anthony
Wed May 28 16:07:48 CDT 2008

"GTN170777" <GTN170777@discussions.microsoft.com> wrote in message
news:B6124F2D-7963-4889-AB77-41EBB62077C3@microsoft.com...
> Hi guys,
>
> Your expertise would be so appreciated on this one, I'm using CS3 and MS
SQL
> server,
>
> There is a field where a user may need to enter the pound sign, for
instance
> "£24,000 per annum plus benefits" etc
>
> The problem is that somewhere during the insert update it changes the £
> pound sign to either a #hash or it inserts the value without the £pound
> sign...
>
> The page lauguage is -
>
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
>
> the details in the head section are
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <script type="text/javascript" src="../Scripts/currentdate.js"></script>
> <html xmlns="http://www.w3.org/1999/xhtml">
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
>
> The SQL Collation is SQL_Latin1_General_CP1_CI_AS
>
> I'm kind of at a loss as to what the problem is with the £ pound sign??
>
> Is there maybe a way or catching and changing the £ sign before insert or
> update??
>
> PLEASE -- PLEASE help
>

I take it this page contains a form. Does it post back to this same page or
does the form action point elsewhere.

The page seems confused as to its character encoding. The codepage says
65001 which is UTF-8 whereas you have a meta content-type specifying
ISO-8869-1.

You should ensure that both the Form page and the page pointed at by the
action attribute both use the same codepage and that the charset in the
content type header matches the codepage encoding.



--
Anthony Jones - MVP ASP/ASP.NET


Top

=?Utf-8?Q?Re:_ASP_VBScript_insert_/_Update?= by GTN170777

GTN170777
Wed May 28 17:28:05 CDT 2008

Thanks Anthony - spot on.

G

"Anthony Jones" wrote:

> "GTN170777" <GTN170777@discussions.microsoft.com> wrote in message
> news:B6124F2D-7963-4889-AB77-41EBB62077C3@microsoft.com...
> > Hi guys,
> >
> > Your expertise would be so appreciated on this one, I'm using CS3 and MS
> SQL
> > server,
> >
> > There is a field where a user may need to enter the pound sign, for
> instance
> > "£24,000 per annum plus benefits" etc
> >
> > The problem is that somewhere during the insert update it changes the £
> > pound sign to either a #hash or it inserts the value without the £pound
> > sign...
> >
> > The page lauguage is -
> >
> > <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
> >
> > the details in the head section are
> >
> > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> > <script type="text/javascript" src="../Scripts/currentdate.js"></script>
> > <html xmlns="http://www.w3.org/1999/xhtml">
> > <head>
> > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> >
> > The SQL Collation is SQL_Latin1_General_CP1_CI_AS
> >
> > I'm kind of at a loss as to what the problem is with the £ pound sign??
> >
> > Is there maybe a way or catching and changing the £ sign before insert or
> > update??
> >
> > PLEASE -- PLEASE help
> >
>
> I take it this page contains a form. Does it post back to this same page or
> does the form action point elsewhere.
>
> The page seems confused as to its character encoding. The codepage says
> 65001 which is UTF-8 whereas you have a meta content-type specifying
> ISO-8869-1.
>
> You should ensure that both the Form page and the page pointed at by the
> action attribute both use the same codepage and that the charset in the
> content type header matches the codepage encoding.
>
>
>
> --
> Anthony Jones - MVP ASP/ASP.NET
>
>
>
Top