Bug #7618 Fresh install MySQL has mysql.user_info table in latin1_swedish_ci
Submitted: 2 Jan 2005 14:51 Modified: 17 Mar 2005 16:26
Reporter: Paul Jones Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:MySQL 4.1.8-nt OS:Windows (XP)
Assigned to: CPU Architecture:Any

[2 Jan 2005 14:51] Paul Jones
Description:
Fresh install and all the tables in the default mysql database are  utf8_general_ci  collation except user_info table in latin1_swedish_ci

It also seems that the default collation is latin1_swedish_ci for new dbs and tables but I need latin1_general_ci or utf8_general_ci 

I can't see any way of setting the default collation (just the character set) on the installer setup.exe

How to repeat:
I've uninstalled and reinstalled from a different mirror but same problem
[2 Jan 2005 16:17] MySQL Verification Team
I did a fresh install and not found the table mysql.user_info:

"Tables_in_mysql"
"columns_priv"
"db"
"func"
"help_category"
"help_keyword"
"help_relation"
"help_topic"
"host"
"tables_priv"
"time_zone"
"time_zone_leap_second"
"time_zone_name"
"time_zone_transition"
"time_zone_transition_type"
"user"

Anyway could you please show the result of:

show create table user_info

Thanks in advance.
[6 Jan 2005 23:20] Michael G. Zinner
This table is created my the MySQL Administrator. Could you state which version of the MySQL Administrator you are using?

The user_info table should be created using a UTF8 charset.
[7 Jan 2005 8:20] Paul Jones
Hi Mike 

That makes sense - it's 1.0.18

Paul
[7 Jan 2005 8:24] Paul Jones
Hi Miguel - sorry for the delay

'user_info', 'CREATE TABLE `user_info` (
  `User` varchar(16) NOT NULL default '',
  `Full_name` varchar(60) default NULL,
  `Description` varchar(255) default NULL,
  `Email` varchar(80) default NULL,
  `Contact_information` text,
  `Icon` blob,
  PRIMARY KEY  (`User`),
  KEY `user_info_Full_name` (`Full_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores additional user information''
[14 Jan 2005 15:47] MySQL Verification Team
Paul, can you try MySQL Administrator 1.0.19?
user_info has utf8 character set for me.
[16 Jan 2005 12:29] Paul Jones
Hi Victoria

I tried the latest 1.0.19 but still get new tables created in latin1_swedish_ci using Administrator
[17 Feb 2005 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[17 Feb 2005 10:13] Paul Jones
Hi - still no resolution
[17 Feb 2005 16:26] MySQL Verification Team
I still can't reproduce it.
What character set settings for the MySQL server do you use?
[18 Mar 2005 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".