Ok, Just a wild guess. CVS = Comma-separated values. In English the decimal separator is a dot '.' In many languages the decimal separator is a comma ','. I guess French uses a comma as the separator. This is probably the most likely cause of the problem. In general I think it is better that to "force" the programming logic to use a specific Culture type both when reading and writing a cvs file.
On Jun 15, 12:21 pm, Mike Fry <[email protected]> wrote: > Hi all, > > I'm hoping that there are people out there who can assist with a small > problem that I'm experiencing. It's a problem that I don't think I'm > able to create a suitable test environment for simply because I don't > have the relevant language version of Windows. > > Basically, I have an application that reads and writes CSV files for > capturing genealogical data prior to uploading to a web site. This has > been developed using VB.NET 2005 Express and is based on the .NET 2.0 > framework. THIS IS A DESKTOP APPLICATION - before all you web > enthusiasts start jumping in. > > OK then! What's happening is this. On my machines and many, many others, > data is getting written in a form that is accepted by the web site. > After all, it's just plain text! There is one machine, in France, that > is causing me problems. Data is being written here with the UTF-8 file > signature and certain characters are being 'escaped' in the UTF-8 fashion. > > Now, the vast majority of my users from all round the world, are > probably using various English versions of Windows. From Windows 2000 > upwards, including one or two 64-bit Vista users and they don't exhibit > this problem. At least, if they do, they're not complaining to me! > > What is it about this one French system, apparently set up as an English > system, that is giving rise to this anomaly? Is there anything I can do > from a coding point of view to stop this from happening? Would using > Invariant Cultures make a difference? > > I hope someone can help me. I'm gradually tearing out what little hair > I've still got left. > > -- > Regards, > Mike Fry > Johannesburg.
