I have a site that is using fckeditor version 2.6.6 to edit it's pages. I am having a problem using text on a page that is written in Simple Chinese. When I past it into the editor, the text shows properly, but after I have saved it to the database, it is returned as just question marks.
The copy is stored in an MS SQL 2000 db in an ntext field. My page encoding is UTF-8. I am running CF 9.0.1 on a Windows 2003 server. The sql type that I am using for my cfqueryparam is cf_sql_longvarchar. My SQL Server collation is SQL_Latin1_General_CP1_CI_AS. Anyone have any thoughts as to why this copy is not being stored properly? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
