RE: How to specify CHAR column to accept specific characters

>-Original Message- >From: hezjing [mailto:hezj...@gmail.com] >Sent: Thursday, June 18, 2009 5:04 AM >To: mysql@lists.mysql.com >Subject: How to specify CHAR column to accept specific characters > >Hi >I'm using MySQL 5.1. > >How do we create a const

Re: How to specify CHAR column to accept specific characters

Hi, I'm using MySQL 5.1. How do we create a constraint on char column to accept only character 'A' - 'Z'? MySQL doesn't have CHECK constraints, I think the only way to do this is via a BEFORE INSERT trigger. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download

How to specify CHAR column to accept specific characters

Hi I'm using MySQL 5.1. How do we create a constraint on char column to accept only character 'A' - 'Z'? Thank you! -- Hez