Quoting Guy Cohen <[EMAIL PROTECTED]>: > 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?
It certainly can. That's how I handle it in my public websites (where mysql is not under my jurisdiction). > and more importantly what > happens to the current data in the colum when changing its type to > BLOB or VARCHAR BINARY? I'm not even sure mysql allows you to change column type. If it does - just test it by creating a copy of the table (select into...), and doing the change in it. If it doesn't - well, create a copy of the table, drop the original table, create it again with the correct schema, then select all the data from the copy to the newly created table. Voila. 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]
