Highlighted

Storing characters in SQL such as ® registered trade mark

Enthusiast ,
Jul 24, 2014

Copy link to clipboard

Copied

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

Views

601

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Storing characters in SQL such as ® registered trade mark

Enthusiast ,
Jul 24, 2014

Copy link to clipboard

Copied

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

Views

602

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 24, 2014 0

Have something to add?

Join the conversation