In order to provide correct data to our CRM provider we check for changes in our customer data using buffer-compare. However if for instance the name of the customer is corrected from "biest" into "biëst" buffer-compare does not see this as a change. Has anybody encountered this issue too and resolved it?
I could go through each character position of the name comparing the ASCII value of each character, but was wondering if there is a more efficient way to do this.
you can try to use 'binary' with buffer-compare (method or statement)... guess that has to do with collation table used
you can try to use 'binary' with buffer-compare (method or statement)... guess that has to do with collation table used
As Marian said, this has to do with the collation.
You can also see the same effect here:
MESSAGE "é" = "è"
VIEW-AS ALERT-BOX INFO BUTTONS OK.
(Off topic but count not resist making this comment)
Instead is
MESSAGE "é" = "è"
This would be a better example
MESSAGE "éq" eq "èq"=
Thanks all for the information. The BINARY option using buffer-compare did solve the issue.