>It is type CHARACTER.
Then that might very well be the problem, some difference in the SET EXACT or SET ANSI state. I understand this has already been suggested by other replies you got.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)