Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Capturing CR/LF from Memo Field in SQL Table
Message
From
09/08/2012 12:27:23
 
 
To
09/08/2012 12:25:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01550223
Message ID:
01550224
Views:
55
>We would like to maintain the CR/LF when we copy data from FoxPro Memo fields to SQL 2008. They seem to strip out by default. Is there a way to do this?
>
>Thanks,
>Larry

No, CRLF is not stripped out, just SSMS shows results that way in GRID. If you have Results to Text you will see CRLFs.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform