Shulou(Shulou.com)06/01 Report--

Editor to share with you the navicat method to modify the character set type in the table or field. I hope you will gain a lot after reading this article. Let's discuss it together.

When you create a database, you can set a character set for the database, or you can give the table a default character set when you create a table, but if you forget to give it or give it wrong, all you need to do is change the character set. Navicat can easily modify the character set type of a field in the database or data table.

After entering Navicat, connect to the database. Place the mouse over the database that needs to be connected, and double-click the mouse directly to connect quickly.

After the connection is successful, select the table and select [Design Table]. As shown in the following figure:

When you enter the data table, you can see each of your field types and their character sets.

You can see if the character set of your current datasheet is what you need, as shown in the following figure

If not, you can click modify to the character set you need.

Because the character set of the database is different, if you write it in the wrong way, it will cause garbled code or cannot be written. In this way, you can also solve the problem of writing garbled again, provided that the character set used when writing is exactly the same as the stored character set.

After reading this article, I believe you have a certain understanding of how navicat modifies the character set types in tables or fields. If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.