Bruce (kor27) wrote,
Bruce
kor27

So, I've Managed to Break MySQL

I just tried changing a few fields over to UTF-8, so I could use the utf_general_ci collation (it's the only one that handles ÿ the way I want it to). I'm still simply playing with the web interface, and the interesting thing is that I now can't do a query that returns a large number of fields.

Like artists that contain "a".

I get "error 12" returned, which is apparently "out of memory."

The older stuff is working fine, so it just looks like the effort of dealing with character format translations is taking up huge amounts of memory.

When I have more time, I may just have to see what happens when I translate everything over to UTF-8.

Of course, I could also make snapshots of a lot of my "on-the-fly" modifications that occur during the sort process...
Subscribe

  • A Fair Chunk

    I've added a reasonable chunk of new songs, mostly requests, some of them quite old. Take a look! The track count is up to 24,083, and the unique…

  • Oh yeah! Updates!

    What with all the moving, I haven't kept up with the updates I've made to the collection. But there area a fair chunk of new songs. The track count…

  • A Few

    I have just a few new songs, mostly requests that finally got made. The track count is now 23,973, and the unique song count is 17,595.

  • Post a new comment

    Error

    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 0 comments