tailieunhanh - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P69

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P69: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 322 Chapter 8 ETL Techniques need to describe the structure of the file to BCP. When you use character or Unicode files however you must describe the structure of the data in the file to BCP. For example if it is a delimited file the delimiters need to be specified for BCP to recognize them. Head of the Class. Dealing with Characters and Collations The file storage type that is used can be a common problem when sharing data between different database systems operating systems and organizations. If you receive a data file that has the data stored as character data the way those characters are encoded can be an issue. In SQL Server you describe the encoding of the character data as well as how that data can be sorted and compared using collations. The Unicode character set is able to represent thousands of possible character symbols. The Unicode character set is sufficient for representing characters from all the major languages alphabets and cultures in the world. However non-Unicode character sets typically can represent only 256 possible symbols. So when you create SQL Server instances databases and character columns you need to specify the character set that has the 256 characters you want. When you are transferring data between two systems it is possible that the two systems may have elected to use different sets of characters for their non-Unicode data. BCP gives you a number of ways to deal with the differences. You can use the command line arguments to let bcp know that the data file contains either character -c or unicode -w . You can also specify the specific code page or character set that the data file was encoded with by including the -C argument. Finally you can do column-specific collation assignments using bcp format files. You have probably worked with either comma-separated value csv or tab-separated value tsv files in the past. They store data as values with a delimiter a comma a tab or something else between each of the values. The rows typically