Log in

No account? Create an account
...:::.::. .::...:..
Moon Phase

May 2019
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31

Bruce [userpic]
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...

Current Location: The Duplex
Mood: amusedamused