Jim4Prez wrote: > A little more research: > > select TABLE_NAME, COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME from > INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = > 'mantis_project_category_table' > > TABLE_NAME COLUMN_NAME CHARACTER_SET_NAME > COLLATION_NAME > mantis_project_category_table category iso_1 > SQL_Latin1_General_CP1_CI_AS > > mantis_project_category_table project_id NULL NULL > > mantis_project_category_table user_id NULL NULL > > Why is category the only column in the table with char_set_name or > collation_name?
Because the other two columns are integers, which (at least in MySQL) have no associated character set or collation. As for your original inquiry, I'm not sure why the project_id is higher than the number of projects you have, but it's hard to tell what's going on without having direct access to the database. Incidentally, in version 1.2.x, the project_category_table has been supplanted by a standard category_table that identifies categories by integer ID rather than just by string name. -- John Reese LeetCode.net ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ mantisbt-help mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mantisbt-help
