Replication Server supports replication of encrypted column data between Adaptive Server databases. However, replication of encrypted column data to any non-ASE replicate database is not supported.To replicate non-encrypted data to an ASE database containing an encrypted column, disable the rs_set_ciphertext function string for the Adaptive Server connection.
rs_set_ciphertext
Controls replication of encrypted columns to an Adaptive Server table.
Alter function string rs_set_ciphertext to turn off execution of the ASE-specific command “set ciphertext on.”
alter function string rs_set_ciphertext for some_function_string_class output language ''