On Thu, 26 Feb 2009 22:07:05 -0700 Jerry Davis wrote: > I am using Rational ClearQuest, and am using the CQ Import process to import > from a csv file which I produced on a linux box. > > The linux backend database is Oracle, and is a utf8 database. > The windows box I am using to do the import (there is no import binary on > linux), thinks it is WINDOWS-1252 > > My csv file has some spanish characters. I can see them in the csv file i > produce. However, when I copy from linux (any means like scp, or a samba mount > point), the file characters actually change. > > I have tried installing iconv (using cygwin), and tried: > $ iconv -s -c -f UTF-8 -t WINDOWS-1252 file > newfile > > It does not look the same as when it was on linux. > > Does anyone know what else I could do, to copy a utf8 file to a windows-1252 > file? > > > ok. I tried a lot of stuff. but the one thing that actually worked, was to run the cqperl script on the windows box itself. it was utf8 on the linux box, I could see the text. when i copied the file, via a samba share, or scp in cygwin, the characters actually changed. we don't use ftp on our servers at all, because of security reasons, so I tried sftp. know what, I couldn't find a mode switch on sftp (binary or ascii), so I couldn't get sftp to deal with it correctly. so I copied over my cqperl script to windows, and it worked there. The characters came out right. god, I really hate to have to deal with windows in any way at all. oh btw, if I tried to convert the file on cygwin using iconv. But by the time I got the file over to windows the damage was already done. -- Happy Trails! Jerry (K7AZJ) Hobbit Name: Pimpernel Loamsdown Registered Linux User: 275424 This email's random fortune: Q: What's hard going in and soft and sticky coming out? A: Chewing gum. --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss