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
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