dbTalk Databases Forums  

French accents during export to text file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss French accents during export to text file in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PComtois
 
Posts: n/a

Default French accents during export to text file - 05-29-2008 , 01:21 PM






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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.