richard
18th July 2005, 12:20
Hello,

All our client PC are now in XP, with an English installation and French updating.
From time to time, people are copy/pasting data from outlook or word to baantexts managed by notepad.
If there is an english apostrophe instead a french, the printout of the text is disturbed, the english quotes is round: ‘ the french one straight '
The same problems happens sometimes in customer adresses.

We made a query to correct the texts (with help of BaaN):
update
ttttxt010100 a
set
a.t$text = TRANSLATE(a.t$text, CHR(146), CHR(39) )
where
INSTR(a.t$text, CHR(146) ) > 0

But is there a solution to avoid the problem (terminf or something in that way).

Regards
;