Bingo!!! Thank you so much Dave! On Wed, Jun 29, 2011 at 12:16 PM, Dave Watts <[email protected]> wrote: > >> 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? > > Have you configured the CF datasource to allow Unicode? > > http://www.coldfusionmuse.com/index.cfm/2006/7/6/mssql.unicode > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:345913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
