i have a problem with inserting Arabic data into my database
i'm using Apache, MySql 4.0.24-nt, Coldfusion MX 6.1, on Windows XP Pro sp2
i did everything to enforce my application to use the UTF-8 charset
i used <cfcontent type="text/html; charset=utf-8">
and <cfprocessingDirective pageencoding="utf-8">
and <cfset setEncoding("form","utf-8")>
i have aslo added the following string to my DSN name in Coldfusion
administrtor:
useUnicode=ture&characterEncoding=UTF-8
My query is as follows:
<cfquery datasource="ams_test">
INSERT INTO tbl_questions (Q_ID, Q_Mark, Q_Text)
VALUES ('#Q_ID#', '#FORM.select#', '#FORM.txt_text#')
</cfquery>
it's wokring fine with english data, but when i use my name in arabic it
gives me the following error:
Syntax error or access violation: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right
syntax to use near '1 'D/1H(J')' at line 2
although it is generating a correct sql statement:
SQL INSERT INTO tbl_questions (Q_ID, Q_Mark, Q_Text) VALUES
('C0260AA0-A481-DF60-26BA5C0DEFEDF160', '1', 'åæÇÑ ÇäÏÑèÈê')
DATASOURCE ams_test
VENDORERRORCODE 1064
SQLSTATE 42000
as you can see my name (åæÇÑ ÇäÏÑèÈê) has been magically converted to '1
'D/1H(J')'
any suggestions?
--
manar droubi
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238466
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
