My experience is that mysql will sort hebrew well when not started or even compiled for hebrew support, with VARCHAR style data types (not binary). the character set support is useful when you to do case insensitive sorts,or handle aumels and accented characters properly - both cases are irrelevant for hebrew. Changing th type to binary will allow you to using the ordinance of characters, regardless of character sets, which would only give you more predictable results. any way - thischange (using the ALTER TABLE syntax) is non destructive.
BTW: I prefer storing textual data in the database as unicode (preferably utf8 to facilitate easier display to the web) encoded data in binary fields - it gives predictable enough sorting, and you neednot worry about character sets, especially when aiming for multi-lingual applications (and I do consider english/hebrew being multi-lingual enough to warrant unicode). -- Oded "Ben-Nes Michael" <[EMAIL PROTECTED]> wrote on 31/7/02 10:05: >If it was not compiled with >Hebrew charset why do you >think that any of the >datatype will work well on >sorting Hebrew ? > >----- Original Message ----- >From: "Guy Cohen" ><[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, July 30, 2002 >3:39 PM >Subject: sorting hebrew in >mysql > > >> Hi, >> >> I want to sort a mysql >table, but the charset in the >database is >> Hebrew. I currently *can >not* recompile mysql with >Hebrew or start >> it with >--default-character-set=he >brew. The solution i had in >mind >> was to change the >appropriate colum from >varchar to either BLOB or >> VARCHAR BINARY. Can this >approach help? and more >importantly what >> happens to the current >data in the colum when >changing its type to >> BLOB or VARCHAR BINARY? >> >> >> Thanks, >> >> Guy Cohen >> >> >> -- >> Unix Administration, | >http://www.unixadmin.co.il >> locally and remotely. | >[EMAIL PROTECTED] >> Planning, installation, | >Phone: 03-6201373 >> support & upgrades. | >Location: Tel-Aviv >> >> >=================== >=================== >=================== >======== >> 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] ================================================================= 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]
