Replicating ntext datatypes

For ntext datatypes Replication Agent’s encoding of the character stream affects the byte order of data when it is applied at the replicate database. You can set the lr_ntext_byte_order property to specify the byte order that Replication Agent uses on ntext data to either BigEndian or LittleEndian.

For example, if the replicate database is on UNIX, set the property to big; if the replicate database is on Windows, set the property to little. The default value of lr_ntext_byte_order is big.