Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

bcp output

I have a bcp batch file that is creating an output file correctly...but it is in UCS- 2 Little Endian format format.

How can I do this in ANSI?

bcp "exec database.dbo.datOutDupont" queryout d:\webs\ftpDupont\premierData.dat -w -S SERVER\INSTANCE -T -E -t^|

0
Larry Brister
Asked:
Larry Brister
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you specified -w which is unicode indeed.
you might want to use -c instead?

http://msdn.microsoft.com/en-us/library/ms162802.aspx
0
 
Larry Bristersr. DeveloperAuthor Commented:
angellll,
  Good to hear from you.  Neither one of us has a life apparantly.

I'll try that and see if the feed goes through on Monday.  Thanks...as always.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Neither one of us has a life apparantly.
well, I do have one :) I am currently organizing and playing a chess tournament. during the breaks, I can do a little bit of EE :)
0
 
Larry Bristersr. DeveloperAuthor Commented:
angelIII:
Ah...
In my younger years I played a lot of chess.  Never got past 1826 though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now