SQL Server导入报错:The LocaleID 4 is not installed on this system

问题描述:

通过SQLServer导入导出向导导入中文字符集数据,遇到The LocaleID 4 is not installed on this system.错误。


SQL Server导入报错:The LocaleID 4 is not installed on this system


SQL Server导入报错:The LocaleID 4 is not installed on this system


SQL Server导入报错:The LocaleID 4 is not installed on this system


解决方法:

我发现客户服务器操作系统虽然不支持Chinese (Simplified)这个Locale,但是支持Chinese (people's *)这个Locale,将FlatFileSource的Locale像下面截图中改成Chinese (people's *),然后确保Code page设置为936后,我就将CSV文件成功地导入到了数据库中并且没有出现乱码。


SQL Server导入报错:The LocaleID 4 is not installed on this system















本文转自UltraSQL51CTO博客,原文链接: http://blog.51cto.com/ultrasql/1922037,如需转载请自行联系原作者