RE: Adding language support to tables

2013-05-01 Thread Rick James
ou are using an new-enough NDB so that FOREIGN KEYs are implemented? > -Original Message- > From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] > Sent: Wednesday, May 01, 2013 5:53 AM > To: [MySQL] > Subject: Adding language support to tables > > Hi, > &

Re: Adding language support to tables

2013-05-01 Thread Neil Tompkins
s the PRIMARY KEY, and make it ASCII, not UTF8. > That would turn the 4-byte id into a 2-byte string. > > I gather you are using an new-enough NDB so that FOREIGN KEYs are > implemented? > > > -Original Message----- > > From: Neil Tompkins [mailto:neil.tompk...@googlemai

Adding language support to tables

2013-05-01 Thread Neil Tompkins
Hi, I've the following database structure of 4 tables for geographical information CREATE TABLE IF NOT EXISTS `mydb`.`country` ( `country_id` INT NOT NULL , `country_code` CHAR(2) NOT NULL , `name` VARCHAR(255) NOT NULL , PRIMARY KEY (`country_id`) , UNIQUE INDEX `country_code_U