On Thu, 2004-03-11 at 06:49, Burns, John wrote:
> How did you fix the problem in CF?  I just upgraded to MX and we're
> having trouble with data that was put into MySQL by CF is now coming out
> with funky characters in MX.  We're on linux servers and I've tried
> setting the page charset to ISO-8859-1 but to no avail.  Quotes come out
> as little boxes and dashes get screwed up too.  Any ideas?

Are you sure those quotes and dashes are not microsoft word charaters?
Microsoft word's "smart" quotes and dashes use an unnatural part of the
code page - meaning they map to nonsense.

Since it's a MS word error (and it is an error to map invalid characters
to any thing you want regardless of your net profit), the error carries
over from MS made up charset -> MySQL (iso-8859-1) -> CFMX/Java
(internally Unicode) -> the page encoding (iso-8859-1 or UTF-8)

Dont allow invalid word charaters and you shouldnt get "little blocks" -
diamonds to doughnuts cflib has a tag for it...

If its not word charaters then never mind. :)

Cheers,
--
Rob <[EMAIL PROTECTED]>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to