From: Martijn Tonies
Date: June 18 2009 10:17am
Subject: Re: How to specify CHAR column to accept specific characters
List-Archive: http://lists.mysql.com/mysql/217893
Message-Id: <012001c9effe$06636a40$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="utf-8";
	reply-type=original
Content-Transfer-Encoding: 7bit

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 Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com