intresting.
Please report back when youll try it, i wonder if it will work on postgresql. locale sorting slow postgresql :( ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Ben-Nes Michael" <[EMAIL PROTECTED]> Cc: "Guy Cohen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 12:45 PM Subject: Re: sorting hebrew in mysql > 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] > > ================================================================= 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]