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=hebrew. 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]