Issue "e EQ ë" using equation including buffe

Posted by fmodderman@grandvisionbenelux.com on 19-Dec-2014 01:58

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.

Posted by Marian Edu on 19-Dec-2014 02:12

you can try to use 'binary' with buffer-compare (method or statement)... guess that has to do with collation table used

Posted by gabriel.lucaciu on 19-Dec-2014 03:03

BUFFER-COMPARE( ) method
This method does a rough compare of any common fields, determined by name, data type, and
extent-matching, between the source buffer and the target buffer. The resulting logical value is
either TRUE or FALSE as a whole.
BUFFER-COMPARE(source-buffer-handle[,mode-exp[,except-list[,pairs-list[,no-lobs]]]])

If mode-exp is given, it must evaluate to either “binary” or “case-sensitive” to provide that
type of comparison.
Or by switching to UTF-8 encoding, that might work also.
Regards,
Gabriel

All Replies

Posted by Marian Edu on 19-Dec-2014 02:12

you can try to use 'binary' with buffer-compare (method or statement)... guess that has to do with collation table used

Posted by gabriel.lucaciu on 19-Dec-2014 03:03

BUFFER-COMPARE( ) method
This method does a rough compare of any common fields, determined by name, data type, and
extent-matching, between the source buffer and the target buffer. The resulting logical value is
either TRUE or FALSE as a whole.
BUFFER-COMPARE(source-buffer-handle[,mode-exp[,except-list[,pairs-list[,no-lobs]]]])

If mode-exp is given, it must evaluate to either “binary” or “case-sensitive” to provide that
type of comparison.
Or by switching to UTF-8 encoding, that might work also.
Regards,
Gabriel

Posted by Lieven De Foor on 19-Dec-2014 03:07

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.

Posted by Bill Wood on 19-Dec-2014 06:53

(Off topic but count not resist making this comment)

Instead is
MESSAGE "é" = "è"

This would be a better example
MESSAGE "éq" eq "èq"=

Posted by fmodderman@grandvisionbenelux.com on 19-Dec-2014 07:26

Thanks all for the information. The BINARY option using buffer-compare did solve the issue.

This thread is closed