How to remove UCS-2 surrogate pairs in SQL Server?
来源:互联网 发布:淘宝服务商入驻 编辑:程序博客网 时间:2024/05/28 04:54
遇到的问题:
Error during charset conversion of wstring: No error
解决方案:
第一步:找出UCS-2 surrogate pairs
SELECT * FROM chartest WHERE text LIKE NCHAR(0xdc83)
第二步:用NULL替换
UPDATE chartest SET text = NULL WHERE text = ''
参考文献:http://dba.stackexchange.com/questions/37343/sql-server-to-mysql-migration-how-can-i-remove-ucs-2-surrogate-pairs-in-sql-se
0 0
- How to remove UCS-2 surrogate pairs in SQL Server?
- how to add linked server in SQL server.
- How To Use Dynamic Sql in Sql Server ?
- How to remove the action suffix extension in Struts 2
- How to remove the action suffix extension in Struts 2
- How To: Reset Identity column in SQL Server
- How to search the available space in SQL server.
- How to delete duplicate rows without children in sql server
- How to shrink the tempdb database in SQL Server
- How to enable remote connections in SQL Server 2008?
- How to backup and restore database in SQL Server
- How to modify the xml in sql server
- How to remove ^M in the file
- how to remove submodule in git
- Sql Server - How to write a Stored procedure in Sql server
- how to remove value in ArrayList in java
- An example to show how to make Tree structure data table in SQL server
- How to install Mysql in linux server
- C语言的枚举类型
- 关于mybatis的关联查询中id错误赋值的解决方法
- MD5Utils
- Solr
- 利用libvirt创建快照
- How to remove UCS-2 surrogate pairs in SQL Server?
- 水平集(2)-演化控制方程
- Activity的启动模式
- 【CSS3】nth-last-of-type(n)选择器
- eclipse相关设置
- 如何用云服务解决短视频社交产品锥心之痛
- Linux平台代码覆盖率测试工具GCOV的前端工具LCOV简介
- ubuntu 14.04 部署vsftpd
- Maven学习 (一) 搭建Maven环境