Saving Arabic words into a database

[AliHabib]

I have a database with column of type nvarchar , to let me insert Arabic words, but when insert using the asp code the insertion appear wron in DB (sql server 2005)

Open_User_ID = session("UserId") RPT_USER_ID = request("RepId") TCKT_SEVERITY_ID = request("severity") TCKT_DESC = replace(request("Desc"),"'","''") TCKT_SUB_PRJ_ID = REQUEST("SubPrjId")
 
SQL="insert into TCKTs (TCKT_DESC, TCKT_SEVERITY_ID, Open_User_ID, RPT_USER_ID, TCKT_SUB_PROJ_ID) values ('"&TCKT_DESC&"', '"&TCKT_SEVERITY_ID&"', '"&Open_User_ID&"', '"&RPT_USER_ID&"', '"&TCKT_SUB_PRJ_ID&"')" DBConn.Execute(SQL)

when check the database I found the column TCKT_DESC display something like that
هاااااااااا&#;ااااي

[jhardman]

Try converting the characters to binary before storing them in the db, then when displaying, convert them back to characters. The column type should be binary or blob. Let me know if this helps.

Jared