Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting french accents to text file

Status
Not open for further replies.

pcomtois

Programmer
May 29, 2008
1
0
0
CA
Hello all.

I am running a MSSQL2000 standard server. I want to export tables to a flat text file using DTS. The problem I have is that most french accents gets transformed into commas in the result file.

Some random stuff that may be helpful:
-Collation: SQL_Latin1_General_CP850_CI_AI.
-Using SQL Query Analyser, all accents come up fine.
-Using "return all rows", all accents come up fine.
-Procedure is a simple Export Data with a text file as destination.

Thanks in advance for any tips or pointers.
pcomtois
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top