Sign in
Albert (Gong) Cheng's blog
A blog about programming, cloud computing, medicine, electronic medical record and healtcare IT.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Tags
.NET
Amalga
assembly
azure
BCP
BCP Utility
character entity
Cloud Computing
Encoding
git
github
Health Solutions
HealthVault
Java
Jenkins
Latin character
Media
Node
OData
perforce
Performance
PHP
ReadOuterXml
reflection
Ruby
Sentillion
SQL Server
Unicode
UTF16
UTF8
version control
Video
Web Service
Windows Azure
Xml
XmlReader
Browse by Tags
MSDN Blogs
>
Albert (Gong) Cheng's blog
>
All Tags
>
utf8
Tagged Content List
Blog Post:
How to import UTF8 encoded string into SQL server using BCP utility?
Albert (Gong) Cheng
The short answer is no. SQL server BCP utility is not capable of recognizing UTF8 encoded string correctly, even worse, it won't report any error, it will simply treat UTF8 encoded string as ASCII encoded string. These string will become unrecognizable characters in SQL Server. As a result, I usually...
on
19 Mar 2010
Page 1 of 1 (1 items)