Re: PHP-MYSQL Question

2009-04-07 Thread Spiros Papadopoulos
it is not the ENGINE as Eugene mentioned above, is that you need to use UNSIGNED when creating the second table CREATE TABLE table2 ( table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, table1_id INT UNSIGNED NOT NULL, name VARCHAR(100) NOT NULL, school VARCHAR(100) NOT NULL, comment TEXT NOT

MySQL 5.1.22 and Greek Language

2007-11-25 Thread Spiros Papadopoulos
Hi, I am having a problem with Greek character set in MySQL 5.1.22 in Windows XP where i am trying to have a column with greek and another one with english text in the same table. I am setting through the MySQL Query Browser tool the character set for each column and in Command Line to greek and