> have you tried £
Don't wanna hijack the Q, but (in a similar vein) does anyone know why the apostrophes and double-quotes in this Access db are getting output as squares? http://www.handsthurrock.co.uk/news/item.cfm?NewsItemID=100
the character set used in your character data columns in the database appears to be windows 1252 / ANSI. This is a super-set of the standard western European character set (ISO-8859-1 aka ISO-Latin-1)
the apostrophes and quotes in your database are characters which are part of windows 1252 but not part of ISO-8859-1
here's a code snippet I use when reading form fields prior to insertion into the database to get around this issue...
if ( stPD.convertANSI ) {
// replace windows 1252/ANSI characters which are not also part of ISO-Latin-1
// with their nearest equivalent Latin-1 character or a HTML entity
// note: will need to revisit this code for Mac compliance (Mac Roman also makes use
// of the 128-159 range and some chars are different than windows 1252)
newValue = replace(newValue,chr(128),"€","ALL");
newValue = replace(newValue,chr(130),"&##8218;","ALL");
newValue = replace(newValue,chr(131),"&##402;","ALL");
newValue = replace(newValue,chr(132),"&##8222;","ALL");
newValue = replace(newValue,chr(133),"&##8230;","ALL");
newValue = replace(newValue,chr(134),"&##8224;","ALL");
newValue = replace(newValue,chr(135),"&##8225;","ALL");
newValue = replace(newValue,chr(136),"&##710;","ALL");
newValue = replace(newValue,chr(137),"&##8240;","ALL");
newValue = replace(newValue,chr(138),"&##352;","ALL");
newValue = replace(newValue,chr(139),"&##8249;","ALL");
newValue = replace(newValue,chr(140),"&##338;","ALL");
newValue = replace(newValue,chr(142),"&##381;","ALL");
newValue = replace(newValue,chr(145),"&##8216;","ALL");
newValue = replace(newValue,chr(146),"&##8217;","ALL");
newValue = replace(newValue,chr(147),"&##8220;","ALL");
newValue = replace(newValue,chr(148),"&##8221;","ALL");
newValue = replace(newValue,chr(149),"&##8226;","ALL");
newValue = replace(newValue,chr(150),"&##8211;","ALL");
newValue = replace(newValue,chr(151),"&##8212;","ALL");
newValue = replace(newValue,chr(152),chr(126),"ALL");
newValue = replace(newValue,chr(153),"&##8482;","ALL");
newValue = replace(newValue,chr(154),"&##353;","ALL");
newValue = replace(newValue,chr(155),"&##8250;","ALL");
newValue = replace(newValue,chr(156),"&##339;","ALL");
newValue = replace(newValue,chr(158),"&##382;","ALL");
newValue = replace(newValue,chr(159),"&##376;","ALL");
}
// replace ISO-Latin-1 currency character and ISO-Latin-9 euro character with euro HTML entity
newValue = replace(newValue,chr(160),"€","ALL");
if ( stPD.escapeHTML ) {
// HTML Escape the rest of the string, which will allow unicode chars not in ISO-Latin-1 which have
// been posted to be saved as HTML entities even if our db doesn't support unicode
// replace &, <, > and " with control chars before running HTMLEditFormat() so we can preserve them
newValue = replace(newValue,"&",chr(25),"ALL");
newValue = replace(newValue,"<",chr(26),"ALL");
newValue = replace(newValue,">",chr(27),"ALL");
newValue = replace(newValue,"""",chr(28),"ALL");
// HTMLEditFormat me
newValue = htmlEditFormat(newValue,"-1");
// put &, <, > and " back where they belong
newValue = replace(newValue,chr(25),"&","ALL");
newValue = replace(newValue,chr(26),"<","ALL");
newValue = replace(newValue,chr(27),">","ALL");
newValue = replace(newValue,chr(28),"""","ALL");
}
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
