ColdFusion 8: Built-in Support for MySQL 4/5
Comments
This was one of the features mentioned in the 1 hour free "ColdFusion 8 Beta Preview" at www.lynda.com.
# Posted By Phillip Senn
| 6/2/07 9:18 AM
Errrr.... and? Or are you just letting folks know about the free preview?
# Posted By Raymond Camden
| 6/2/07 9:23 AM
If you have your MySQL on a Linux box and would like to have Unicode support, you still need to use the old method to define your DSN.This is the JDBC URL which is created by default: "jdbc:mysql://localhost:3306/mydatabase?"
It must be like "jdbc:mysql://localhost:3306/mydatabase??useUnicode=true&characterEncoding=UTF-8 "
You can find detailed instructions MySQL installation as manual on page: http://howtoforge.com/coldfusion7_mysql4.1_connect...
# Posted By O?uz Demirkap?
| 6/2/07 12:33 PM
speaking of... we recently knocked out some mysql sites on one of our servers when we did the 7.02 upgrade. woops. What a pain to manually upgrade each sites driver.
# Posted By Emmet
| 6/2/07 12:47 PM
"If you have your MySQL on a Linux box and would like to have Unicode support, you still need to use the old method to define your DSN."Not true. Just create a datasource with the new driver marked MySQL 4/5 and then add the options useUnicode=true&characterEncoding=UTF-8 to the Connection String field. The options automatically get appended to the JDBC URL.
# Posted By Lars
| 6/2/07 2:06 PM
It was one of the first things I noticed since I screwed up and deleted all my settings and had to add my DSN back... I was like YES native 4/5 support.
# Posted By J.J. Merrick
| 6/2/07 6:18 PM
Support for PostgreSQL is built-in too?Rob
# Posted By Roberto
| 6/3/07 8:54 AM
Yes, but wasn't it in earlier?
# Posted By Raymond Camden
| 6/3/07 9:02 AM
No, i had to 5 download the Jar driver and set up a custom DSN.Thanks
Rob
# Posted By Roberto
| 6/4/07 1:36 AM