SQLTeam.com | Weblogs | Forums

The letter 's' is causing escape

I have a string of base 64 encoded image. Its really long, and casues the string to not be red in the MS SMS.
Deleting the characters backwards to the start, the character that casues it to go red is "s" at 32769 position. .
I have already escaped all the '/' . Any ideas?
I'm trrying to store it in the DB.
Thanks.

please see if this help!!! :slight_smile: :slight_smile:

http://www.intstrings.com/ramivemula/articles/escape-special-characters-in-tsql/

I wouldn't use SSMS to manually INSERT large chunks of data into the database. Use BULK INSERT into a staging table as a first step.

BULK INSERT dbo.myStagingTable
FROM '\\MyServername\D$\source\data\myData.txt

Once the data is in the staging table it is easy to transfer it to its final table.

I don't use BULK INSERT often, but you can find more information here.

(Another option is OPENROWSET.)