G
GTN170777
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
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