Quoting Ben-Nes Michael <[EMAIL PROTECTED]>: > If it was not compiled with Hebrew charset why do you think that any of the > datatype will work well on sorting Hebrew ?
Because when you convert to a binary type, the sorting is done on a byte-by-byte basis rather than character by character. Since Hebrew is straight-forward when it comes to collation - no accents to be sorted together with the associated letter - sorting it by the character's encoding works very well. Herouth ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]