Change default collation? PHPMYADMIN

squaredeye · 2006-01-12 02:36:56

Somehow or another I ended up with a bunch of my tables collated as latin1_Swedish_ci in my textpattern db.

I wanted to migrate to another db (dump and import), but I encountered the collation error when I suggested it import as UTF8.

Any suggestions how I might change the collation on all of them at once?

Matthew

zem · 2006-01-12 04:05:57

Unless something is broken, I’d recommend leaving well enough alone. MySQL’s collation and charset handling is a disaster when it comes to upgrading and migrating.

If you must, there is some info here.

squaredeye · 2006-01-12 12:35:23

Zem,
Thanks, To test, I changed collation per table to utfx_unicode_ci, and everything seems to be working fine. I have very little article wise in the database. Disaster’s suck, so far this seems to be working fine.

In the future, if a DB table set is mixed in its collation, what’s the best method of import?

Sencer · 2006-01-12 14:39:19

I think you are mixing up Collation and charsets. The two are different and serve different purposes. See the link mentioned above.

squaredeye · 2006-01-12 14:54:32

Thanks Sencer,
Your new avatar is rediculous!

Textpattern CMS

Textpattern CMS support forum

#1 2006-01-12 02:36:56

Change default collation? PHPMYADMIN

#2 2006-01-12 04:05:57

Re: Change default collation? PHPMYADMIN

#3 2006-01-12 12:35:23

Re: Change default collation? PHPMYADMIN

#4 2006-01-12 14:39:19

Re: Change default collation? PHPMYADMIN

#5 2006-01-12 14:54:32

Re: Change default collation? PHPMYADMIN

Board footer