it looks like your csv file is UTF-8 encoded. But arimportcmd is expecting a 
file encoded in your native codepage. (CP1252)
 
Try to open the file in notepad and in the "Save As" Dialog choose "ANSI" 
encoding and save the file.
 
HTH
 
Kind Regards Conny

________________________________

Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Hellyson
Gesendet: Donnerstag, 13. August 2009 17:06
An: arslist@ARSLIST.ORG
Betreff: ARIMPORTCMD Problem with accentuation


** I have a problem when I try to import some data with accentuation using 
arimporcmd command at the MS-DOS

Here, in Brazil, we use accentuation  (^,~,´, etc) in some words, when i try to 
import a csv file, in the arimport.log displays the correct data, but in the 
arsql.log displays the wrong data.

Example:
Log of Import
**** Marcão;5/7 - 11/7/2009;Sexta;;;;Ausência;;;

Log of SQL:
SELECT T95.C1 FROM T95 WHERE ('MarcÃo' = T95.C536870913) ORDER BY 1 ASC

I did the test on my machine, development server and approval server.

Operation System: Windows
DB: Microsoft SQL Server 2003
ARS Server Version: 7.1.00 Patch 002


------------------------------------------------
Hellyson
helly...@gmail.com
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 

Reply via email to