Don�t know if it was on this list or another but someone mentioned yesterday that Mysql automatically escapes certain characters (e.g. \ ) this may be the problem.
HTH Kola >> -----Original Message----- >> From: Tim Blair [mailto:tim@;rawnet.com] >> Sent: 13 November 2002 10:37 >> To: [EMAIL PROTECTED] >> Subject: [ cf-dev ] MySQL Character Oddities >> >> >> Morning all, >> >> In the system we're creating the client wants to store UK pound symbols >> (�) in the database (as part of a service description etc). Looking at >> the database, everything's inserted fine. However, when I go to >> retrieve the string back from the DB, I get back an odd character. If I >> do an asc() on this char I get back the value 65443 and doing >> replace(string, chr(65443), "£") works fine. >> >> So that's a workaround, but the question remains where is this value >> coming from? The UKP chr() value is 163 so that's what I thought should >> be returned. The other oddity is that if I do ALT+065443 within >> HomeSite+ it prints out "£" for me. ??? >> >> Any clues? >> >> Cheers, >> >> Tim. >> >> >> ------------------------------------------------------- >> Tim Blair >> Web Application Engineer, Rawnet Limited >> Direct Phone : +44 (0) 1344 393 441 >> Switchboard : +44 (0) 1344 393 040 >> ------------------------------------------------------- >> rawnet ltd >> Atrium Court >> Bracknell [EMAIL PROTECTED] >> Berkshire Tel : +44 (0) 1344 393 040 >> RG12 1BW, UK http://www.rawnet.com >> ------------------------------------------------------- >> This message may contain information which is legally >> privileged and/or confidential. If you are not the >> intended recipient, you are hereby notified that any >> unauthorised disclosure, copying, distribution or use >> of this information is strictly prohibited. Such >> notification notwithstanding, any comments, opinions, >> information or conclusions expressed in this message >> are those of the originator, not of rawnet limited, >> unless otherwise explicitly and independently indicated >> by an authorised representative of rawnet limited. >> ------------------------------------------------------- >> >> >> >> >> >> -- >> ** 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] -- ** 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]
