Data Compare

3 views
Skip to first unread message

Vicegodgiarc

unread,
May 9, 2008, 12:40:08 AM5/9/08
to DB Solo
Hi,

I ahve been comparing two identical SQLServer tables with the
following schema:
Position Name Data Type Nullable Length Digits
1 Log_Time_Date... datetime false 23 3
2 Occurrence_No varchar false 9 0
3 Log_Entry text true 2147483647 0
4 Username varchar true 50 0
5 Manual_Entry smallint true 5 0

Seems that the Log_Entry has not been matching correctly, even when
reducing the set comparison to only a few rows.

Is there an issue comparing text?

Regards
Craig

DB Solo

unread,
May 9, 2008, 8:09:19 AM5/9/08
to DB-...@googlegroups.com
Seems to work correctly as far as I can tell. Could you post/email the
CREATE TABLE statement and a couple of INSERT statements for both
sides that would demonstrate the problem?

Marko

Reply all
Reply to author
Forward
0 new messages