When submitting to a DB\Textworks textbase via ODBC using Cold Fusion I receive the error below when using any ASCII character between the values 127 to 228 which includes many symbols and character I need (€,á,ß,™,©,¼,½...).

Error Message is:
unknown exception condition

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:47) in the template file D:\Inetpub\wwwroot\devrob\ODBCCharTest\dbt-addnew.cfm.

I can submit these characters to an access database using cold fusion and I can submit them to db\textworks using the odbc driver with ASP but just not the combination of CF with DBT ODBC.

Although this message is shown the data is in the textbase but obviously I need to acheive this without the error.

Also once an error has occured you cannot submit any character without receiving the same error message.

Has anyone experienced the same? Does anyone have a solution?