My boss was so pleased with the response from this site that he asked me to ask another question! He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!).
In any case, we build a new db (schema) prior to loading it with data. Is there a way to change the character set on a new, empty db to prevent any errors? Is there some command we can use?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!