SQL Server Import Error: The LocaleID 4 is not installed on this system

Problem Description:

Import the Chinese character set data through the SQL Server Import and Export Wizard, and encounter the LocaleID 4 is not installed on this system. Error.

650) this.width=650; "title=" clip_image001 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image001 "src=" Http://s3.51cto.com/wyfs02/M01/93/64/wKiom1kKzbizhHCXAAB4pE5y5OQ875.png "height=" 579 "border=" 0 "/>

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image002 "src=" Http://s3.51cto.com/wyfs02/M02/93/64/wKiom1kKzbjDibFHAACGIWaxSlQ630.png "height=" 578 "border=" 0 "/ >

650) this.width=650; "title=" clip_image003 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image003 "src=" Http://s3.51cto.com/wyfs02/M00/93/64/wKiom1kKzbmAjeyvAABHxMqXY78428.png "height=" 281 "border=" 0 "/ >

Workaround:

I found that the client server operating system does not support the locale of Chinese (Simplified) but supports the locale of Chinese (People's Republic of China), Change the locale of FlatFileSource to Chinese (People's Republic of China), and then make sure that the code page is set to 936 and I successfully import the CSV file into the database without garbled characters.

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image004 "src=" Http://s3.51cto.com/wyfs02/M00/93/63/wKioL1kKzb3xbHzRAAB5IS1_sxA621.png "height=" 581 "border=" 0 "/>

This article is from the SQL Server deep Dive blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1922037

SQL Server Import Error: The LocaleID 4 is not installed on this system