Re: Cannot create partition with ASCII function.

[Phil Hildebrand]

There are only a few functions currently you can use with partitioning:

http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html

ASCII isn't on the list.

In your case (depending on the complexity of the project), it might make more sense to break out the Job Code to another table so you end up with a job_id (integer) in the employee table that logically references the new job_code_type table or something, then you could do it.

Depending on your queries as well, it might make sense to partition employee's on store_id instead of job_code (depending on your reason for wanting to partition on job_code)