0 Replies Latest reply on Jul 24, 2014 9:42 AM by ACS LLC

    Storing characters in SQL such as ® registered trade mark

    ACS LLC Level 1

      I've set my datasource advanced settings to higher end Ascii characters along with unicode.

       

      I'm inserting data into MS SQL using <cfqueryparam cfsqltype="cf_sql_char" value="#listgetat(form.apps,1)#"> and I've changed the settings in the database to NVARCHAR

       

      I can cut and paste a registered trade mark along with a few other special characters (and foreign language) directly into the database and they store just fine

       

      When I scrape HTML from a site, parse and then try to store it from a SQL INSERT, I end up injecting question marks where some of the special codes go, some seem to store, I've seen some Chinese and Russian characters in there.

       

      Can anybody help?

       

      Thanks

       

      Mark