son Posted December 22, 2009 Share Posted December 22, 2009 I choose 'utf8-general-ci' as collation for any varchar or text fields. The database and tables themselves always show 'latin1_swedish_ci'. Does this affect the data? Is the collation of field taking precedence over the table and database collation? Can and should I change this in phpMyAdmin? Son Link to comment Share on other sites More sharing options...
justsomeguy Posted December 22, 2009 Share Posted December 22, 2009 The field takes precedence, the table collation is just the default if you don't specify it for a field. You can change the table collation if you want to. Link to comment Share on other sites More sharing options...
son Posted December 23, 2009 Author Share Posted December 23, 2009 The field takes precedence, the table collation is just the default if you don't specify it for a field. You can change the table collation if you want to.I saw that you can change the table collation (have done this for several tables). Can this also be done for whole database (accessed via phpMyAdmin which is provided by hosting company, so I do not have access to configuration file as such). As field takes precedence (thanks for feedback) I do not need to change this, but would just like to know...Son Link to comment Share on other sites More sharing options...
justsomeguy Posted December 23, 2009 Share Posted December 23, 2009 Yes, you can also set a database default. Link to comment Share on other sites More sharing options...
son Posted December 23, 2009 Author Share Posted December 23, 2009 Yes, you can also set a database default.Just found it. In Operations...Many thanks,Son Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.