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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.