Mgccl Posted April 27, 2007 Share Posted April 27, 2007 anyone got a query that can change every table and every field's collation that is latin1_swedish_ci to utf8_general_ci? I have a lot tables and fields and I need to do it manually one by one in phpmyadmin, that could cost me like 3 days. BTW it's mysql version 4.1 thx in advance Link to comment https://forums.phpfreaks.com/topic/48859-query-that-convert-the-entire-databases-collation-to-utf8_general_ci/ Share on other sites More sharing options...
fenway Posted April 27, 2007 Share Posted April 27, 2007 Just dump the describe somewhere, and write a quick & dirty shell script to produce the required alter statements. Link to comment https://forums.phpfreaks.com/topic/48859-query-that-convert-the-entire-databases-collation-to-utf8_general_ci/#findComment-239988 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.