Is this in MX? I hgad some strange goings on inserting characters into a DB from a form using MX - possibly a related problem.
I haven't got the solution here right now but I can send it to you a bit later. Giles ----- Original Message ----- From: "Tim Blair" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 13, 2002 10:37 AM 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]
