inserting utf-8 data using ado recordset to ms sql
My script gets input form a form with UTF-8 charset and wants to save the fields in database using adodb recordset and addnew method (NOT using SQL INSERT). i have charset=utf-8(client-side) and session.codepage=65001 in my asp file. it works fine with MS access but when it comes to MS SQL 7 or 2000, even i have nchar data type(unicode support) in my table , the ??? characters inserted in db instead of actual input. the cause is that MS SQL default encoding is not UTF-8,so MSDN recommends using "N" prefix with INSERT commands and it works. now the question is that is there any possible solution to ADODB recordset addnew or update methods to work with UTF-8 data in MS SQL enviroment?