Options

Treat LF as CR LF

ioaniioani Posts: 2
edited March 18, 2013 11:55AM in SQL Data Compare Previous Versions
Hi,

I have a table that has a nvarchar column. This column rows contains text on many lines. When I compare the table from different DBs some rows have new lines coded as CR LF other as LF. How can be made LF to be treated as CR LF so that two identical rows not to be treated as different because of different new lines?

Thanks
· Share on Twitter

Comments

  • Options
    Manfred.CastroManfred.Castro Posts: 209
    Unfortunately there is not an option such that two identical rows not to be treated as different because of different new lines
    There is an existing feature request you may want to vote for.
    http://redgate.uservoice.com/forums/147 ... roject-opt
    These forums are actively monitored by our development team and allow our users to reuest features and vote on them.
    If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
    Manfred Castro
    Product Support
    Red Gate Software
    · Share on Twitter
Sign In or Register to comment.