Archive for the Category »Coldfusion «
Problem description-
Setup MySQL database and CF DSN but the Hebrew characters fail to display properly – UTF8.
Temporary work around-
Recreate the DSN and set the driver type from MySQL 3 to MySQL 4/5
Note: This solves only for characters already stored in the DB – if I update the text using coldfusion – then ? Marks appear instead
Permanent solution-
Please include this code in your script-
<cfscript>
setEncoding(”URL”, “UTF-8″);
setEncoding(”Form”, “UTF-8″);
</cfscript>
At the top of form loading script.
In CFAdmin, under the connection string field specify these piece of entry-
useUnicode=true&characterEncoding=UTF-8
Problem description-
When creating Datasource with MS Access or MS Access Unicode driver seleceted produces this error even though there is valid Access database file-
Connection verification failed for data source: DSN name
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
Solution-
Chose “other” as the driver type and entered the following:
JDBC URL:
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[Full path to your database file];DriverID22;
Driver Class:
sun.jdbc.odbc.JdbcOdbcDriver
Drive Name:
MS Access via JDBC
Recent Comments