This content has been marked as final. Show 3 replies
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51
> Driver][mysqld-4.0.26-standard]You have an error in your SQL syntax. Check the
well first off don't use ODBC, use the JDBC driver (probably should get the
latest from mysql & config it as "other" in the dsn section of cfadmin). second,
*is* the version of mysql that you're running unicode capable? third, did you
set the database encoding to unicode/utf-8?
Yes, it seems MySQL unicode capable ... cause i will try to implement same script by PHP (on the same table, same DB), and it performs great !
Maybe ane other advice ? Maybe i can in someway ron PhP script from CF to perform this mechanism ? ANY solution required !
thanks in advance !
But i have only control panel with only ODBC access ...
please , if i will ask hosting provider, how i can explain him about prooer JDBC settings ?
Thanks in advance !