Re: utf8_bin collation sorting incorrectly?

2005-11-08 Thread Eric Herrera
also.. ascii characters(1-127) sort correctly using utf8_bin Eric Herrera wrote: I'm attempting to sort using utf8_bin and I don't think its sorting properly. I believe I have everything set correctly. I've appended all related data. I also have a small perl script below which I used to

Re: utf8_bin collation sorting incorrectly?

2005-11-08 Thread Paul DuBois
At 19:05 -0500 11/7/05, Eric Herrera wrote: I'm attempting to sort using utf8_bin and I don't think its sorting properly. I believe I have everything set correctly. I've appended all related data. I also have a small perl script below which I used to generate the tests. I may be wrong, but I

Re: utf8_bin collation sorting incorrectly?

2005-11-08 Thread Eric Herrera
Sorry. In hast, I copied the wrong results. I generated a new set-here they are: = 1) WHAT IS INSERTED = ord binary 0fc1 4033

utf8_bin collation sorting incorrectly?

2005-11-07 Thread Eric Herrera
I'm attempting to sort using utf8_bin and I don't think its sorting properly. I believe I have everything set correctly. I've appended all related data. I also have a small perl script below which I used to generate the tests. I may be wrong, but I expect this query: select id, utf8_data from