DB2 import data load command Chinese garbled Solution

Source: Internet
Author: User


Note the Chinese garbled characters in the load command for DB2 data import solution: when you use the load command on windows to import tables to the database today, the Chinese characters in the data are garbled. Command: The Chinese characters in the table www.2cto.com db2 load from d: \ user.txt of del insert into useruser are garbled. Www.2cto.com solution: add the codepage option when using the load command. Command: db2 load from d: \ user.txt of del modified by codepage = 1386 insert into usercodepage = 1386 for GBK, 1208 for UTF-8. NOTE: If db2 is installed on a linux server, using the load command to import data is faster, but it is possible
As a result, the backup of the db2 database on linux is suspended and data cannot be written to the database.
Backup. Therefore, use this command with caution and try to use other methods instead.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.