Skip to main content
Inspiring
July 24, 2014
Question

Storing characters in SQL such as ® registered trade mark

  • July 24, 2014
  • 0 replies
  • 709 views

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

    This topic has been closed for replies.