I have a csv file on the server encoded as ANSI, and want to open it, process and save the content on the database. I'm having infinite problems with the accented character as "à è ì ò ù", getting instead "?".
The content in the html header is set as utf-8. This is my code
Response.CharSet = "UTF-8"
...
Set objStream = CreateObject("ADODB.Stream")
objStream.Type = 2
objStream.CharSet = "utf-8"
objStream.Open
objStream.Position = 0
objStream.LoadFromFile( path )
strData = objStream.ReadText()
Response.write(strData) '<== just to see
objStream.Close
Set objStream = Nothing
At first I was using a single FileSystem object, but read that it has even more problems handling encoding