mysql and latin characters

[PaulH]

yes that's jdbc.

[nathangg]

Originally posted by: PaulH
the page encoding is still coming up as utf-8 on that link you posted, so i'm
not sure what you've actually done. those changes do indeed work.


Okay, I made the following changes
* connection string to mysql 4.0.18-nt database in CF administrator is "using
useUnicode=true&characterEncoding=iso88591"
* Added the following lines to application.cfm:
<cfset setEncoding("url","ISO-8859-1")>
<cfset setEncoding("form","ISO-8859-1")>
<cfcontent type="text/html; charset=ISO-8859-1">

* I added the following line to index.cfm, inc_header.cfm, inc_banner.cfm,
inc_menu.cfm and program.cfm:
<cfprocessingdirective pageEncoding="ISO-8859-1">

You can see what it looks like
[url]http://www.mendozamission.com/index.cfm?sector=mission_program&page=program&miss[/url]
_id=589502

(You'll notice that it looks the same, however, when you look at the encoding,
indeed it has changed.)

So, when I get home from work tonight, I will be change to MS SQL Server (so,
if you want to view the ? marks and boxes, you'll need to do so before 6 or 7
pm Central Time) :-)

Again, THANK YOU so much for your help. I'm sorry if I am doing something
wrong and that is why it is not working.

Thanks!
--
Nathan