<cfset setEncoding("FORM", "utf-8")>
might help if you are on MX
Garry
-----Original Message-----
From: Giles Roadnight [mailto:giles@;roadnight.name]
Sent: 13 November 2002 10:42
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] MySQL Character Oddities
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]
--
** 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]
