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...
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.
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
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
Thanks
Rob
# Posted By Roberto
| 6/4/07 1:36 AM