Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 bcp problem forSQL-6.5 to SQL-2005 for cp1256 data

Author  Topic 

ashrefcp
Starting Member

7 Posts

Posted - 2008-01-23 : 04:06:59
Hi Gurus,

source server configuration: cp1256, nocase (SQL Server 6.5 on NT)
destination server configuration: cp1256, nocase (SQL Server 2005 on windows 2003)

I am still facing problem in bcp out and bcp in. The -V65 is tried out. The problem seems to me is that the bcp out from Win-MT at DOS prompt is turning the bcp out file into its own charset format, probably using some preset feature like auto convert for chars.

How to workaround this and get my arabic data in proper way into SQL2005.
Any help is highly appreciated.

Regds,
/ash

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-23 : 22:47:49
Tried use bcp on sql2k5 server to dump sql6.5 data?
Go to Top of Page
   

- Advertisement -