Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JustinBigelow
SQL Gigolo
1157 Posts |
 Posted - 2002-03-24 : 10:41:42
|
| Hi all,I had to take an Access database to SQL Server. I used DTS to do this and for the most part it went fine. However the database contained records with very large memo fields, so I mapped that field to a text column. When I display the data in QA or ASP its all one big jumble, the carriage returns have disappeared. I could run a string function to insert a <br> just before every date (which usually indicated a new line) but adding extra data to the current database to accomodate a specific client (web browser in this case) seems like a no no to me. I'm worried that if I do it when I present the data then performance will go south. Any other thoughts?Thanks,Justin |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-24 : 10:53:13
|
Hey graz, does THIS sound familiar?  How did the CR-LFs disappear? Did DTS strip them out? |
 |
|
|
|
|
|
DTS and Carriage Returns