Character encoding Problem

i have following setup:

 

existing application on cf7 real old mysql database. works fine. using iso-8859-1 everywhere , latin1 on database.

 

now want migrate cf10 mysql 5.1.52 server

 

everything works fine except for, when try change data, i'm trying following query:

 

update db_dj_user set gestaeti='webprogrammierung oder ähnliches äöü' id=10235

 

and failes error

 

incorrect string value: '/xe4hnlic...' column 'gestaeti' @ row 1

 

looking @ page, encoded iso-8859-1

looking @ html-code says <meta http-equiv=content-type content="text/html; charset=iso-8859-1">

looking @ field in database says gestaeti text latin1_swedish_ci

looking @ datasource has connection string of characterencoding=latin1

looking @ iso-8859-1-table e4 correct character german umlaut ä

in application.cfm url , form encoding set iso-8859-1 cfcontent specifies iso-8859-1 , cfprocessingdirective set iso8859-1 (that last in both, application.cfm in template query in)

reading umlauts out of table works fine.

updating data phpmyadmin runs on same apache works fine.

 

 

any idea missing, or did hit bug ?

 

thanks ideas

frank

found following workaround:

 

cd /opt/coldfusion10/cfusion/lib

mv mysql-connector-java-commercial-5.1.17-bin.jar mysql-connector-java-commercial-5.1.17-bin.jar.old

download mysql-connector-java-5.0.8-bin.jar mysql , save in directory.

make new custom datasource url jdbc:mysql://localhost:3306/prod?characterencoding=latin1 driver class com.mysql.jdbc.driver , driver name mysql

restart cf

 

now works. error in commercial connector or problem connection-string-to-jdbc-url-mapping ?

 

-frank

More discussions in Database Access

adobe