Win XP test C:\mysql507\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.23-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select version(); +------------+ | version() | +------------+ | 5.0.23-log | +------------+ 1 row in set (0.03 sec) mysql> CREATE TABLE `people` ( -> `id` int(11) NOT NULL auto_increment, -> `name` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `surname` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `maiden_name` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `picture` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `entry_date` date NOT NULL, -> `birth_date` date NOT NULL, -> `gender_id` int(11) NOT NULL, -> `birthplace` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `citizenship` tinyint(1) NOT NULL, -> `telephone` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `gsm` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `email` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `address` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `postcode_id` int(11) NOT NULL, -> `temp_address` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `temp_postcode_id` int(11) NOT NULL, -> `marital_status_id` int(11) NOT NULL, -> `nr_children` int(11) NOT NULL, -> `child_care_id` int(11) NOT NULL, -> `spouse_employed` tinyint(1) NOT NULL, -> `spouse_employment` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `residence_id` int(11) NOT NULL, -> `profession_id` int(11) NOT NULL, -> `education_level_id` int(11) NOT NULL, -> `title_id` int(11) NOT NULL, -> `previous_education` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `professional_courses` text collate utf8_slovenian_ci NOT NULL, -> `recommence_schooling` tinyint(1) NOT NULL, -> `next_education` text collate utf8_slovenian_ci NOT NULL, -> `computer_knowledge` tinyint(1) NOT NULL, -> `smoker` tinyint(1) NOT NULL, -> `drivers_license` tinyint(1) NOT NULL, -> `working_years` float NOT NULL, -> `expected_wages` float NOT NULL, -> `employment_agency` tinyint(1) NOT NULL, -> `employment_agency_from` date NOT NULL, -> `financial_support` float NOT NULL, -> `disability` tinyint(1) NOT NULL, -> `afternoon_work_id` int(11) NOT NULL, -> `professional_ambitions` text collate utf8_slovenian_ci NOT NULL, -> `leisure` text collate utf8_slovenian_ci NOT NULL, -> `interests` text collate utf8_slovenian_ci NOT NULL, -> `interview` tinyint(1) NOT NULL, -> `interviewer` int(11) NOT NULL, -> `interview_date` date NOT NULL, -> `grade_id` int(11) NOT NULL, -> `entry_by` int(11) NOT NULL, -> `comments` text collate utf8_slovenian_ci NOT NULL, -> `reference_id` int(11) NOT NULL, -> `opinion` text collate utf8_slovenian_ci NOT NULL, -> `suitable_work` text collate utf8_slovenian_ci NOT NULL, -> PRIMARY KEY (`id`), -> KEY `gender_id` (`gender_id`), -> KEY `postcode_id` (`postcode_id`), -> KEY `temp_postcode_id` (`temp_postcode_id`), -> KEY `marital_status_id` (`marital_status_id`), -> KEY `child_care_id` (`child_care_id`), -> KEY `residence_id` (`residence_id`), -> KEY `profession_id` (`profession_id`), -> KEY `education_level_id` (`education_level_id`), -> KEY `title_id` (`title_id`), -> KEY `afternoon_work_id` (`afternoon_work_id`), -> KEY `interviewer` (`interviewer`), -> KEY `entry_by` (`entry_by`), -> KEY `grade_id` (`grade_id`), -> KEY `reference_id` (`reference_id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=2; Query OK, 0 rows affected, 1 warning (0.16 sec) mysql> select distinct(`people`.`id`) as table_record_id , `people`.`id` as `id`, -> `people`.`name` as `name`, `people`.`surname` as `surname`, -> `people`.`maiden_name` as `maiden_name`, `people`.`picture` as `picture`, -> `people`.`entry_date` as `entry_date`, `people`.`birth_date` as `birth_date`, -> `people`.`gender_id` as `gender_id`, `people`.`birthplace` as `birthplace`, -> `people`.`citizenship` as `citizenship`, `people`.`telephone` as `telephone`, -> `people`.`gsm` as `gsm`, `people`.`email` as `email`, `people`.`address` as -> `address`, `people`.`postcode_id` as `postcode_id`, `people`.`temp_address` as -> `temp_address`, `people`.`temp_postcode_id` as `temp_postcode_id`, -> `people`.`marital_status_id` as `marital_status_id`, `people`.`nr_children` as -> `nr_children`, `people`.`child_care_id` as `child_care_id`, -> `people`.`spouse_employed` as `spouse_employed`, `people`.`spouse_employment` as -> `spouse_employment`, `people`.`residence_id` as `residence_id`, -> `people`.`profession_id` as `profession_id`, `people`.`education_level_id` as -> `education_level_id`, `people`.`title_id` as `title_id`, -> `people`.`previous_education` as `previous_education`, -> `people`.`professional_courses` as `professional_courses`, -> `people`.`recommence_schooling` as `recommence_schooling`, -> `people`.`next_education` as `next_education`, `people`.`computer_knowledge` as -> `computer_knowledge`, `people`.`smoker` as `smoker`, `people`.`drivers_license` -> as `drivers_license`, `people`.`working_years` as `working_years`, -> `people`.`expected_wages` as `expected_wages`, `people`.`employment_agency` as -> `employment_agency`, `people`.`employment_agency_from` as -> `employment_agency_from`, `people`.`financial_support` as `financial_support`, -> `people`.`disability` as `disability`, `people`.`afternoon_work_id` as -> `afternoon_work_id`, `people`.`professional_ambitions` as -> `professional_ambitions`, `people`.`leisure` as `leisure`, `people`.`interests` -> as `interests`, `people`.`interview` as `interview`, `people`.`interviewer` as -> `interviewer`, `people`.`interview_date` as `interview_date`, -> `people`.`grade_id` as `grade_id`, `people`.`entry_by` as `entry_by`, -> `people`.`comments` as `comments`, `people`.`reference_id` as `reference_id`, -> `people`.`opinion` as `opinion`, `people`.`suitable_work` as `suitable_work` -> from `people` order by surname ASC, name ASC limit 0,50; Empty set (0.03 sec) mysql> show variables like "%char%"; +--------------------------+-----------------------------+ | Variable_name | Value | +--------------------------+-----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | C:\mysql507\share\charsets\ | +--------------------------+-----------------------------+ 8 rows in set (0.01 sec) mysql> Suse 10 test mysql> select version(); +-----------+ | version() | +-----------+ | 5.0.24 | +-----------+ 1 row in set (0.03 sec) mysql> show variables like "%char%"; +--------------------------+---------------------------------------------------- -------+ | Variable_name | Value | +--------------------------+---------------------------------------------------- -------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /home/Tonci/bkwork/copyto/mysql-5-0/share/mysql/cha rsets/ | +--------------------------+---------------------------------------------------- -------+ 8 rows in set (0.00 sec) mysql> CREATE TABLE `people` ( -> `id` int(11) NOT NULL auto_increment, -> `name` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `surname` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `maiden_name` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `picture` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `entry_date` date NOT NULL, -> `birth_date` date NOT NULL, -> `gender_id` int(11) NOT NULL, -> `birthplace` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `citizenship` tinyint(1) NOT NULL, -> `telephone` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `gsm` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `email` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `address` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `postcode_id` int(11) NOT NULL, -> `temp_address` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `temp_postcode_id` int(11) NOT NULL, -> `marital_status_id` int(11) NOT NULL, -> `nr_children` int(11) NOT NULL, -> `child_care_id` int(11) NOT NULL, -> `spouse_employed` tinyint(1) NOT NULL, -> `spouse_employment` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `residence_id` int(11) NOT NULL, -> `profession_id` int(11) NOT NULL, -> `education_level_id` int(11) NOT NULL, -> `title_id` int(11) NOT NULL, -> `previous_education` varchar(255) collate utf8_slovenian_ci NOT NULL, -> `professional_courses` text collate utf8_slovenian_ci NOT NULL, -> `recommence_schooling` tinyint(1) NOT NULL, -> `next_education` text collate utf8_slovenian_ci NOT NULL, -> `computer_knowledge` tinyint(1) NOT NULL, -> `smoker` tinyint(1) NOT NULL, -> `drivers_license` tinyint(1) NOT NULL, -> `working_years` float NOT NULL, -> `expected_wages` float NOT NULL, -> `employment_agency` tinyint(1) NOT NULL, -> `employment_agency_from` date NOT NULL, -> `financial_support` float NOT NULL, -> `disability` tinyint(1) NOT NULL, -> `afternoon_work_id` int(11) NOT NULL, -> `professional_ambitions` text collate utf8_slovenian_ci NOT NULL, -> `leisure` text collate utf8_slovenian_ci NOT NULL, -> `interests` text collate utf8_slovenian_ci NOT NULL, -> `interview` tinyint(1) NOT NULL, -> `interviewer` int(11) NOT NULL, -> `interview_date` date NOT NULL, -> `grade_id` int(11) NOT NULL, -> `entry_by` int(11) NOT NULL, -> `comments` text collate utf8_slovenian_ci NOT NULL, -> `reference_id` int(11) NOT NULL, -> `opinion` text collate utf8_slovenian_ci NOT NULL, -> `suitable_work` text collate utf8_slovenian_ci NOT NULL, -> PRIMARY KEY (`id`), -> KEY `gender_id` (`gender_id`), -> KEY `postcode_id` (`postcode_id`), -> KEY `temp_postcode_id` (`temp_postcode_id`), -> KEY `marital_status_id` (`marital_status_id`), -> KEY `child_care_id` (`child_care_id`), -> KEY `residence_id` (`residence_id`), -> KEY `profession_id` (`profession_id`), -> KEY `education_level_id` (`education_level_id`), -> KEY `title_id` (`title_id`), -> KEY `afternoon_work_id` (`afternoon_work_id`), -> KEY `interviewer` (`interviewer`), -> KEY `entry_by` (`entry_by`), -> KEY `grade_id` (`grade_id`), -> KEY `reference_id` (`reference_id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=2; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql> select distinct(`people`.`id`) as table_record_id , `people`.`id` as `id`, -> `people`.`name` as `name`, `people`.`surname` as `surname`, -> `people`.`maiden_name` as `maiden_name`, `people`.`picture` as `picture`, -> `people`.`entry_date` as `entry_date`, `people`.`birth_date` as `birth_date`, -> `people`.`gender_id` as `gender_id`, `people`.`birthplace` as `birthplace`, -> `people`.`citizenship` as `citizenship`, `people`.`telephone` as `telephone`, -> `people`.`gsm` as `gsm`, `people`.`email` as `email`, `people`.`address` as -> `address`, `people`.`postcode_id` as `postcode_id`, `people`.`temp_address` as -> `temp_address`, `people`.`temp_postcode_id` as `temp_postcode_id`, -> `people`.`marital_status_id` as `marital_status_id`, `people`.`nr_children` as -> `nr_children`, `people`.`child_care_id` as `child_care_id`, -> `people`.`spouse_employed` as `spouse_employed`, `people`.`spouse_employment` as -> `spouse_employment`, `people`.`residence_id` as `residence_id`, -> `people`.`profession_id` as `profession_id`, `people`.`education_level_id` as -> `education_level_id`, `people`.`title_id` as `title_id`, -> `people`.`previous_education` as `previous_education`, -> `people`.`professional_courses` as `professional_courses`, -> `people`.`recommence_schooling` as `recommence_schooling`, -> `people`.`next_education` as `next_education`, `people`.`computer_knowledge` as -> `computer_knowledge`, `people`.`smoker` as `smoker`, `people`.`drivers_license` -> as `drivers_license`, `people`.`working_years` as `working_years`, -> `people`.`expected_wages` as `expected_wages`, `people`.`employment_agency` as -> `employment_agency`, `people`.`employment_agency_from` as -> `employment_agency_from`, `people`.`financial_support` as `financial_support`, -> `people`.`disability` as `disability`, `people`.`afternoon_work_id` as -> `afternoon_work_id`, `people`.`professional_ambitions` as -> `professional_ambitions`, `people`.`leisure` as `leisure`, `people`.`interests` -> as `interests`, `people`.`interview` as `interview`, `people`.`interviewer` as -> `interviewer`, `people`.`interview_date` as `interview_date`, -> `people`.`grade_id` as `grade_id`, `people`.`entry_by` as `entry_by`, -> `people`.`comments` as `comments`, `people`.`reference_id` as `reference_id`, -> `people`.`opinion` as `opinion`, `people`.`suitable_work` as `suitable_work` -> from `people` order by surname ASC, name ASC limit 0,50; Empty set (0.00 sec)