Input Chinese Character

[cybersabah]

I having problem to insert chinese character from textarea input into MS Access
DB, the funny character save into DB?
I try out <meta http-equiv="Content-Type" content="text/html;charset=utf-8" >
but still the same result?
Anyone can help?

[PaulH]

cf ignores that meta header. you need to be using the access for unicode driver.

[BKBK]

PaulH's solution is ideal. However, if you don't have Admin access to the
database,
then put this code in your Application.cfm or Application.cfc:



<!---
The code in the scriptlet ensures that variables in form and url scope,
i.e. client input, remain in Unicode format, irrespective of the encoding
that the client uses.
--->
<cfscript>
SetEncoding("form","utf-8");
SetEncoding("url","utf-8");
</cfscript

[PaulH]

well whether or not you use access for unicode (but you *have* to if you want your data captured properly), you certainly should be using bkbk's code snippet--it's a good practice.

[cybersabah]

I can insert the chinese character, but having the problem to insert long text
into Ms Access memo field?
I try to insert the text like 2 paragraph still ok but more than that came out
the error message?

Message like:
Error Executing Database Query.
Application uses a value of the wrong type for the current operation.

But i try to open my Ms access and paste into the Memo field it work OK??