BCP IN ISO-8859-1 (ISO-LATIN-1) TYPEFACE

Hot Topic

Where can I find SQLCMD?
Bulk Insert Speed Problems
Copy Data from Access to SQL Express in Code?
SSIS & SharePoint Lists
Where to find the logs in DB
image causing extra page in PDF export
Hierarchical XML import?
Timeout error on SQL Server Express 2005
Can't open SQL database
Automatic Backup SQL Server Express

SQL Server

Article: Database Mirroring Not Ready for Production When SQL Server 2005 Ships
How to Execute a DiffGram
Windows synchronization manager and subscriber web synchronization
Reports run under my credentials, not those stored on report
Using SSMS to Manage SSIS
Mirroring, Snapshot Replication, load balancing and other BIG questions
Creation of offline Cubes in SSAS 2005
How to restore, transfer or copy a sql 2005 database to sql 2000 server
How to restore SQL 7 DB to SQL 2005
exporting russian and polish text to pdf

BCP IN ISO-8859-1 (ISO-LATIN-1) TYPEFACE

I NEED TO BCP DATA FROM A TABLE TO BE COMPLIANT WITH THE

ISO-8859-1 (ISO-LATIN-1) TYPEFACE

IS THERE A SWITCH I CAN USE TO TAKE CARE OF THIS.

EMAD

Answer this question

BCP IN ISO-8859-1 (ISO-LATIN-1) TYPEFACE

Amshanti
I am not sure what you mean by compliance with ISO-LATIN-1. If your column collation is specified correctly then BCP will automatically preserve that upon export. So when you create the data file you should get the characters exported correctly. BCP also has the -C option where you can specify the code page used for character translation explicitly but this parameter is meant for backward compatibility purposes.
BCP IN ISO-8859-1 (ISO-LATIN-1) TYPEFACE

Answer this question