Problem with replicating float data

[Piotr Wawak]

We have set up transactional replication between two SQL7
servers and between SQL7 and Oracle server.

Everything was running fine for a few months until a few
days ago replication stopped with "insert" error on both
subscribers.

As it turns out INSERT statements sent to subscribers
contain data in float columns with ',' as a decimal point
instead of correct '.' (for instance '1,000e+01' instead
of '1.000e+01').

Obviously this is treated by a subscriber as two values
instead of one and an error is returned.

I checked language settings for all user accounts used for
replication. Everything seems to be OK.

Just a few days ago float data was formatted with a proper
separator. I don't know what had happened that changed
this situation.

Can you help ?

[TSVK]

Could you be more specific as to what you changed?

"Piotr Wawak" <piotr...@orlen.pl> wrote in message
news:79d801c115b0$cd046810$a5e62ecf@tkmsftngxa07...

[Piotr Wawak]

The problem is that everyone tells me that nothing was
changed.

The only thing that happened was that the publishing
server had been restarted. After that the replication
failed.

I ommitted the offending transactions allowing one of the
subscribers to get updated but any new transactions with
float data are formatted in the same (wrong) way.

The other server has thousands of transaction waiting to
be replicated so I am unwilling to push them manually
(many of them are incorrect).

>.
>