What database is good for data over 1 GB? 10

There are several factors to consider:

How fast the data grows (if it grows quickly, the amount of data in the future will be large, I recommend Oracle).

I recommend Oracle if the requirements for the application are high (for example, integrity and consistency are required, and data needs to be backed up regularly).

Cost considerations (the cost of Oracle is relatively high, and it is more difficult to learn) 3G data is not particularly large now, SQL Server is a good choice, better than MySQL, and I personally feel that it is easier to learn and operate than Oracle, of course, if you want to make a big application, the data will be very large in the future (such as TB level), it is very good to use Oracle, and then you have to use DB2, and choose IBM host (such as Z9).

It's just a personal opinion, you can consider using sqlserver first

Large data volumes, commonly used are SQL Server or Oracle

If you have a foundation, it's better to use Oracle!

In addition, the data can be analyzed to see if the data can be broken down and placed in multiple tables, so that the amount of data in a single table is small and the operation is convenient.

There are a lot of GB8888 encoding tables on the Internet, I have ** GB8888 and GBK, Unicode encoding tables, but they are not access database files, you can try to import these encoding tables (generally recorded with notepads) to the access database!

Oracle has an advantage over large data volumes.

A terabyte-level database is a database that stores more than 1 terabyte of data, and 1 terabyte is equivalent to a trillion bytes, which is a large capacity.

Computer capacity is generally expressed in kb, mb, gb, tb, and the relationship between them is:

1B is a byte, 1KB (Kilobyte) = 1024B, 1MB (Megabyte = 1024KB), 1GB (Gigabyte also known as "Gigabyte") = 1024MB, 1TB (Trillionbyte Trillion Byte) = 1024GB, where 1024 = 2 10 (2 to the 10th power).

Note: "Mega" is a unit of millions of quantities.

The above is the storage relationship calculated by Microsoft Corporation (Microsoft). The average hardware manufacturer calculates it like this:

1kb=1000b

1mb=1000kb

1gb=1000mb

1tb=1000gb

A terabyte-level database means that the overall capacity of the database is measured in T, for example, 1T=1024G

Method 1:

Open the database using Microsoft Access 2000 and select Tools menu Database Utilities Convert Database to an earlier Access database version.

Method 2: Add <%@codepage ="936"%> to the beginning of each page.

It looks like this: %@codepage ="936" %>import namespace="" %>import namespace="" %>import namespace="" %>

The number of words entered is the same as in the data table. Did you change to GB2312? It turns out what is encoding, see if the string field is gb2312 encoded.

PHP can add a setting statement.

mysql_query("set names 'gbk'");

If the number is not too much, it is recommended to continue to use Excel because the operation of the database is more difficult than Excel.

If Excel can't be installed, you should first consider access, because it is a component of Office, and the operation may be simple.

If the database requirements are not very strict, it is relatively easy to use access or mysql.

You can also use SQL Server, you should quickly learn to use it simply by looking for someone around you to guide you, or you can find a basic book on the Internet, but you have to put your mind down and learn!

Uh, 200g? It won't be a lottery or something! In this case, it is easier to find someone to help you develop a small piece of software to deal with.

When creating a database, use uf8 general ci and declare the encoding header( in the header of **"content-type: text/html; charset=utf-8");If you use gbk, the encoding setting language in the gb2312 database is no problemgbk Chinese ci, gb2312 Chinese ci, and it is best to add this sentence set names utf8 when linking the database

Before executing a query in PHP, you need to execute the following **::

mysql_query("set character_set_connection=utf8, character_set_results=utf8, character_set_client=binary");

Enter set names gbk directly into the database;

The first point: his phpmyadmin, the new database changed to utf8

Point 2: If you can't do the first step, take the following: export in your own phpmyadmin, select the character set GB2312 when importing on the server, and it will be automatically converted.

I don't know what effect you need to achieve, whether you need to export the data or modify the content data in the database and not export it. The easiest way for the latter is to export the data content to SQL, then modify the database encoding settings, and then modify the encoding of the exported SQL script to GB2312 and then import it; In the case of the former, you can export the CSV directly.

Export to CSV first, save it as ASCII or Unicode, and then create a new library and table, use GB2312 characters, import, and you're good to go.

mysqldump -h -p 3307 -u username --default-character-set=utf-8 -p databasename >

Then open the exported file with Notepad or EditPlus and other software, and then change the UTF-8 after the charset of the Create Database statement to GB2312, and change the Set Names UTF-8 to Set Names GB2312 (if not, add one yourself before Create Database).

Then select the save as function, when saving, the encoding selection gb2312gb2312 encoding is easy to appear garbled, because it lacks many characters such as traditional Chinese characters, the general database storage uses utf-8, and the input end needs the data of gb2312 to convert it by itself.