• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

OpenTextFile in FSO

Hi everybody,

I'm using ASP to read from a txt file and write some of the contents of it to a DB...

But there is a problem with the character set. Those txt files have on them some Greek phrases and when i'm trying to read them they come to my screen as garbage characters..

I know that, when i'm opening the file I have to open it as OEM Character Set but I dont know how to do it.. I tried to open it as unicode, ASCII but it didnt help me out....

Can anyone help me please ?
  • 4
  • 4
1 Solution
Sounds like a character set difficulty.  See http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/charsets/charset4.asp

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=windows-1253">
<%@Language=VBScript codepage=1253%>
Miracle_GrAuthor Commented:
Unfortunately this solution didnt help me out :( I've tried everything including changin the LCID) but still got the problem..

Any other ideas ???
How about copying and pasting the Greek into your HTML page directly... just to make sure you can view them to begin with.

Also - are the characters being entered into the database correctly?  (Are they being read correctly just not displayed on screen correctly)?

In case you haven't guessed - now I am grasping at straws.  ;-)
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Miracle_GrAuthor Commented:
Well, in fact my problem is that the file that I read with FSO has the OEM Chartacter Set.. So when I use :

<meta http-equiv="Content-Type" content="text/html; charset=ibm737">

I can perfectly read the content of the file on the browser with correct characters..

But when I try to update my DB still I have the problem of characters... I have to find a way :

a - To open my file with FSO in OEM Character Set Format
b - To open the file in ASCII format and then convert it to OEM.

I dont know how to do them both...

I tried to find a way for the OpenTextFile method to open the file in OEM format but I think that there isnt any !!

I tried to find a script for the conversion but still havent found one !!!

I have to solve this issue and I have to solve it today :(((
Public software from Diomidis D. Spinellis, Associate Professor in the Department of Management Science and Technology of the Athens University of Economics and Business, and director of the ELTRUN Research Center - Software Engineering and Security (SENSE) group (home page: http://www.dmst.aueb.gr/dds/):



One caution:

Hope this helps!
Miracle_GrAuthor Commented:
Thanks Zeesparow for your interest but I managed to solve the problem with another way..

I found a little progy (4Kb) which does exactly what I want (conversion from OEM to ANSI) so before the file process using ASP and WScript I run that program on specific file, save it on another location and continue my work on the new file.

But thanks again to you for your interest..
Miracle_Gr - thanks for the points.  Sorry I didn't help further.
What program is it (and where did you find it) if I may ask?
Miracle_GrAuthor Commented:
Hi ZeeSparrow,

I found that proggy on the internet site : http://www.geocities.com/SiliconValley/Garage/5238/Download.html

Name of the author is Louis Lecaroz...

Its a 4 Kb Exe file that makes that convertion perfectly..

See ya..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now