Unicode searches in MySQL

MySQL usually sucks for Unicode searches. They have tuned their partial text search for 4 character words or more – certainly, not what the doctor ordered when it comes to the normally 2 or 3 character asiatic language set. However I ran into something interesting today.
SELECT *
FROM `ads`
WHERE `description` LIKE ‘%経%’
LIMIT 0 , 30

This seems to work perfectly. Hrm. I just need to fix the damn classified section and I’m set.

Alito and your daughters.

This is so retarded.

This is the reason I wouldn’t vote the Democrats if I was American. Reading this dramatic garbage is enough to make me cry.

Here’s a few alternatives if you are worried about your daughter needing an illegal abortion

  1. Try sitting down and telling her the inevitable outcome of sex. REMINDER: Your daughter just might not need an abortion if she isn’t busy having sex all the time.
  2. Try to convey the importance of family planning.
  3. Remember that all this means, if the dire terror comes true, is that abortion will become a States right issue. No need to get the coat hangers out yet, you sick bastards.

Oh and one last thing. Please encourage childless homosexuality as an alternative lifestyle for your children. They will be awful parents if they are anything like you.

Generating a login system in Ruby on Rails

The Classified section is rolling right along. Right now, I need to fix up something with the login & security.

The first issue is that anyone can edit an advertisement – and that anyone can delete any advertisement as well. This is because several functions (destroy, create, etc..) are not password protected. This clearly needs to change. Advertisements need to be associated with a certain user account, and only editable by that user – or by an administrator. I believe the first place I need to turn to is the Salted Hash Login Generator on the Ruby on Rails website.

The second issue is that there needs to be some way to prevent spammed listings. I need to implement some form of CAPTCHA (Completely Automated Public Turing Test to Tell Computers and Humans Apart). I think I have managed to google one over here. Let’s see how it goes. (I only intend to implement the first part today)