Copy/Paste from Word to DB - NOOOO!

Posted By: jonathansampson | Jul 3rd @ 7:55 AM
page 1 of 1
Comments: 4 | Views: 378
#Jul 3rd @ 7:55 AM
jonathansampson
jonathansampson
stick a scissor in you eye!

Any of you guys ever have encoding problems with your text when you copy from a rich-text editor like Word, or Wordpad into something like MySQL? It jacks up certain characters, like ? ' , ... and --. What is the deal here? I'm not sure if this is encoding, or what, but I'm interested in figuring out why it does this. I typically have to go through each entry and manually delete the character (which appears italisized usually) and manually retype it again, so that it appears normal.

Any insight?

Jonathan Sampson

#Jul 3rd @ 8:38 AM
foreachdev
foreachdev
Doesn't he look like a winner
Yep always paste into Notepad first. Word et al are eval.

Some editors will have word format stripper.
#Jul 3rd @ 12:12 PM
Red5
Red5
Systems Manager Curmudgen
If all you want is the raw text, then the Notepad copy-first is a good route to take.

If you want to actually retain the RichText formatting of what you see in Word...you may need a nvarchar datatype or something along thsoe lines, in your database that will hold some of those funky characters...or maybe put the whole Word Doc in as an BLOB.
#Jul 3rd @ 1:23 PM
figuerres
figuerres
???
Hmmm....   try making a small clipbaord test app and see what format word drops in to the clipboard...

if it's Unicode and the target is not then that will for sure mess it up.

also the reciving app has to pull the data from clipboard ... trying to recall how clipboard handles richtext , does it keep a plain and a rich version?

been a while since I did Clipboard stuff...
#Jul 3rd @ 2:50 PM
figuerres
figuerres
???
where are you pasting the text? in a db row? in the sql editor ?

page 1 of 1
Comments: 4 | Views: 378