copyright symbol

Date	2014-06-04 14:36 +1000
From	Andrew Poulos <ap_prog@hotmail.com>
Newsgroups	comp.lang.javascript
Subject	copyright symbol
Message-ID	<V_adnebgvuRUPxPOnZ2dnUVZ_vudnZ2d@westnet.com.au> (permalink)

Show all headers | View raw

I have an MS SQL Server database with a copyright symbol in a field of 
data type varchar(80). When this is read by JScript in a classic ASP and 
then displayed in the page the symbol displays as a black diamond with a 
question mark in it.

If I change the page's charset from
   <meta charset="UTF-8">
to
   <meta charset="iso-8859-1">
the symbol correctly displays as a copyright symbol.

Why does changing the charset "fix" the display of the symbol?

I'd rather keep the charset as UTF but I'm at a loss as to what's going on.

Do I need to change the data type?
Do I need to encode the symbol before it goes into the database?
Do I need to unescape/decode the value from the database?

Andrew Poulos

Back to comp.lang.javascript | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

copyright symbol Andrew Poulos <ap_prog@hotmail.com> - 2014-06-04 14:36 +1000
  Re: copyright symbol "Jukka K. Korpela" <jkorpela@cs.tut.fi> - 2014-06-04 08:51 +0300
    Re: copyright symbol "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2014-06-04 10:37 +0200
  Re: copyright symbol Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-04 11:06 +0200
    Re: copyright symbol Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-04 14:34 +0200
      Re: copyright symbol "Jukka K. Korpela" <jkorpela@cs.tut.fi> - 2014-06-04 15:41 +0300
    Re: copyright symbol Andrew Poulos <ap_prog@hotmail.com> - 2014-06-05 10:28 +1000
      Re: copyright symbol "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2014-06-05 09:12 +0200
  Re: copyright symbol Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-04 11:21 +0000

csiph-web