I have found out that some files on the system, have trailing spaces...
To make matters worse I have found 'file ' and 'file ' both
exist, breaking constraint "name".
So am I better off going to TINYTEXT or VARBINARY(255) for the name field?
That said another way, will TINTTEXT break the index (and index speed)?
Will VARBINARY break the way the Connector/J handles the strings (they are
utf8)?
CREATE TABLE paths (
id int(11) NOT NULL auto_increment,
typeref tinyint(4) NOT NULL default '1',
name varchar(255) NOT NULL default '',
ppathref int(11) default NULL,
PRIMARY KEY (id),
UNIQUE KEY name (name,ppathref),
KEY ppathref (ppathref),
KEY typeref (typeref),
CONSTRAINT paths_ibfk_1 FOREIGN KEY (ppathref) REFERENCES paths (id),
CONSTRAINT paths_ibfk_2 FOREIGN KEY (typeref) REFERENCES pathtypes (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218 -
- -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately. Any other use of the email by you
is prohibited.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]