Inserting free form text

[rsmrcina]

Im trying to insert data into the Sugar database fields that have free form text (emails, description fields, etc). These fields can contain CR/LF's. What is the proper way to translate/represent them so that they can be inserted and displayed correctly?

Thanks,
Rich Smrcina
VM Assist

[Angel]

How are you intending to insert the data? Programmatically?

Need further details.

[rsmrcina]

I was planning to use Jitterbit, but if that doesn't work just plain old MySQL LOAD perhaps.

[Angel]

I don't have much hands on experience with Jitterbit, but in the past, I have been able to move data in while preserving CR/LFs by using simple INSERT SQL statements.

In my case, I was pulling data from another DB. I would load the free form text into a variable and simply reference that variable in the INSERT part.

I was doing it with .NET, but I would assume the process would work with other languages as well.

[rsmrcina]

Would mass table loads handle it then? Perhaps I'll have to just resort to that.