This is a multi-part message in MIME format.



------=_NextPart_000_0146_01C19764.70FA9A40

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Someone must have seen this before ...



I have inherited a database that I am using to develop a web site ... 

the database contains several columns of datatype "text" ... whenever I 

extract the information from one of these text columns I get odd 

characters in the text where quotes and dashes should show. Example:



lots of things =F1 everything from (this should be a dash)



find =ECfeathering the nest=EE rewarding (looks like single quotes 

should be here)



more =D6 I would like to take (I have no idea what this should be)



at least 5=ED 7=EE tall and (single and double quotes)



Whenever these characters are displayed in char or varchar fields, 

everything displays properly. Does anyone have any idea how I can 

correct this.



Chip Dukes

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C1978F.86200F10

Content-Type: text/plain; charset="ISO-8859-1"

Content-Transfer-Encoding: quoted-printable



think it's something to do with a 'Enable Character Codeset Conversion'

checkbox on the server - but i'm a bit hazy on that!  It's to do with

Unicode not matching ASCII characters as far as i'm aware.



HTH,

Colin



-----Original Message-----

From: Chip Dukes [mailto:cdukes77@b...]

Sent: 07 January 2002 15:17

To: ASP Databases

Subject: [asp_databases] Strange characters





Someone must have seen this before ...



I have inherited a database that I am using to develop a web site ... the

database contains several columns of datatype "text" ... whenever I extract

the information from one of these text columns I get odd characters in the

text where quotes and dashes should show. Example:



lots of things =F1 everything from (this should be a dash)



find =ECfeathering the nest=EE rewarding (looks like single quotes should be

here)



more =D6 I would like to take (I have no idea what this should be)



at least 5=ED 7=EE tall and (single and double quotes)



Whenever these characters are displayed in char or varchar fields,

everything displays properly. Does anyone have any idea how I can correct

this.



Chip Dukes




$subst('Email.Unsub').







*******



This message and any attachment are confidential and may be privileged or o

therwise protected from disclosure.  If you are not the intended recipient,

 please telephone or email the sender and delete this message and any attac

hment from your system.  If you are not the intended recipient you must not

 copy this message or attachment or disclose the contents to any other pers

on.



For further information about Clifford Chance please see our website at htt

p://www.cliffordchance.com or refer to any Clifford Chance office.