Why N problems occur in the MySQL database

The following article describes N problems with MySQL databases. We all know that the system uses an access database, and there are no problems, but as the data volume keeps increasing, its related performance has been quickly reduced, but at the very least, there is no error.

Considering the future development of the background, I moved to the MySQL database platform, and a bunch of problems suddenly occurred.

1. Chinese characters are not supported.

This is enough for me to be busy for a few hours. I modified my. ini and the link string again. Finally, we have done a good job.

2. The insert time format is not supported.

It's just vomiting blood. In c #, the date contains the Chinese "Morning" and "Afternoon". because MySQL supports Chinese, an error is reported directly during insertion.

This low-level problem is super vomiting, so you have to add a conversion on the persistent layer.

3. The inserted Chinese characters are suddenly lost.

During the test, it was suddenly found that the inserted Chinese characters were not normal, English was normal, and the field type was Text. I vomited blood again. After I couldn't find the method, I had to recreate the MySQL database.

4. Insert BLOb. The image is incorrect.

If the character is converted to byte [], there is no problem. If it is a file or something like that, it will be wrong. It is estimated that it is still a problem of Chinese characters.

You can only modify the persistent layer again and perform base64 encryption on byte.

Vomiting blood !!!!!

5. This is an exception in the official code !!!! Rely on me !!! Boss, who wrote this!

TABLENAME: POS_SALESORDER

LOG: System. ArgumentOutOfRangeException: The index and length must reference the position in the string.

Parameter Name: length

In System. String. InternalSubStringWithChecks (Int32 startIndex, Int32 length, Boolean fAlwaysCopy)

In MySQL. Data. Types. MySQLString. MySQL. Data. Types. IMySQLValue. WriteValue (MySQLStream stream, Boolean binary, Object val, Int32 length)

In MySQL. Data. MySQLClient. MySQLParameter. Serialize (MySQLStream, Boolean binary)

In MySQL. Data. MySQLClient. Statement. SerializeParameter (MySQLParameterCollection parameters, MySQLStream stream, String parmName)

In MySQL. Data. MySQLClient. Statement. BindParameters ()

In MySQL. Data. MySQLClient. PreparableStatement. Execute ()

In MySQL. Data. MySQLClient. MySQLCommand. ExecuteReader (CommandBehavior behavior)

In MySQL. Data. MySQLClient. MySQLCommand. ExecuteNonQuery ()

In Pixysoft. Framework. Noebe. NoebeCommand. Execute ()

Save your life .. Why !!! There is no way to connect to debug this time.

I guess there are still countless problems waiting for me.

Open-source and open-source are not what I mean. And get rid of your contention. I have been working on software for more than five years. Using. net has never been blocked by small problems. I can focus on algorithms and frameworks. However, there are countless small issues when developing java and open source.

For example, hibernate and tmd have been upgraded, and even the namespace has changed. This can be said to directly turn millions of hibernate demo code and helloworld on the Internet into a fee code. How hard this is for beginners.

For example, in eclipse, countless advocates will definitely scold me. However, compared with vs2005, I would rather face numerous sprees than support vs2005. Eclipse has some good functions, but that performance .. That ease of use... Hi .. MB memory at startup. Use a smart reminder to wait for half a day. There are also many packaging, deployment, and many problems. It doesn't mean ant is not good, but I just want to pack it and let me write a bunch of xml files. Besides, like writing code, it is also split into different directories. Help... I am tired of reading code.

Later I came up with a so-called maven program, which specifically targets deployment. How can this problem be solved. It's just a shit. Virus effect immediately when any version changes. The package fails immediately, and the failure is inexplicable. Our engineers can solve this problem only by one or two people, such as modifying the last two digits of the package configuration file version number. The rest are in the fog.

There are also interfaces in java. Don't tell me how javaswing is. At last, it wasn't the c-based SWT launched by IBM that ended the interface nightmare of JAVA. The above content is an introduction to a considerable number of issues with the MySQL database. I hope you will have some gains.