June 29, 2006 at 10:37 am
Hi I am trying to figure out if Im at risk losing data when I bcp OUT and then BULK insert between physical servers. My concern is the codepage and or collation.(is this the same thing? does the codepage determine the collation?
I understand the -N flag on bcp give the best performance; native SQL Server file format. But when I bulk insert with the 'widenative' datafiletype do I specify a codepage? The documentation is not very clear. Many of the flags on bcp only apply to character file types but its just not clear.
First step is to determine the codepage and or collation of my targets and sources i would think. (i dont know how to do that or even if they are the same thing) anyone?
SQL 2012 Standard VPS Windows 2012 Server Standard
June 30, 2006 at 2:09 am
SQL Server 2000 replaces code pages and sort orders with collations. The Client uses the Windows Regional setings, which can be translated using the ODBC or OLE DB connection settings.
Search for "Copying Data Between Different Collations" for BCP / BULK INSERT information and "collation" to learn more about this subject in Books OnLine (BOL).
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply