I am trying to bcp a table to a flat file, and the output does not contain some french characters that are in my data. It replaces them with some invalid characters
The command I am using is
bcp tablename out c:\data\tableName.txt -c -

The -c and -6 are necessary due to some restrictions on the import side of things
Is there some option I have overlooked? I looked at the other bcp options and only saw -R that might apply, but didn't seem to help when I added it.

You might try using the -C parameter and specify the code page that SQL
Server is uisng. You can get this by using the sp_helpsort procedure. You
should see something in the outpu that looks like this:

Code Page 1252 for non-Unicode Data

Use that number with the -C parameter.

Rand
This posting is provided "as is" with no warranties and confers no rights.

I don't get anything that looks like that when I run that proc

This is what I get

Unicode data sorting
----------------------
Locale ID = 1033

case insensitive, kana type insensitive, width insensitiv


Sort Order Description
------------------------------------------------------------------------------------------------------------------------------------
Character Set = 1, iso_
ISO 8859-1 (Latin-1) - Western European 8-bit character set
Sort Order = 52, nocase_is
Case-insensitive dictionary sort order for use with several W
stern-European languages including English, French, and Germa
. Uses the ISO 8859-1 character set

Characters, in Order
------------------------------------------------------------------------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { |
~ ¡ ¢ £ ¤ Â¥ ¦ § ¨ © ª « ¬ Â* ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ Â
¿ × ÷ 0 1 2 3 4 5 6 7 8 9 A=a À=Ã* Ã�=á Â=â Ã=ã Ä=ä Ã…=Ã¥ Æ=æ B=b
=c Ç=ç D=d E=e È=è É=é Ê=ê Ë=ë F=f G=g H=h I=i ÃŒ=ì Ã�=Ã* ÃŽ=î Ã�=ï
=j K=k L=l M=m N=n Ñ=ñ O=o Ò=ò Ó=ó Ô=ô Õ=õ Ö=ö Ø=ø P=p Q=q R=r
=s ß T=t U=u Ù=ù Ú=ú Û=û Ãœ=ü V=v W=w X=x Y=y Ã�=ý ÿ Z=z Ã�=ð Þ=Ã

Just for kicks, I tried using -c -6 -C1033

Didn't work. Got an error that looked like this
SQLState = S1000, NativeError = 8
Error = [Microsoft][ODBC SQL Server Driver]Unicode conversion failed. The code page of the SQL server must be installed on the client system

The interesting thing is it looks like I only got this error for rows that have french characters in them

Try using t -c -6 -C1252

Rand.
This posting is provided "as is" with no warranties and confers no rights.