[dba-Tech] vb script

I do not know much about vb script, but if you know it is coming in as
Unicode, why not use TristateTrue (-1) for the format?  Opening as the
system default may be this issue.

BTW, is there an RSS feed for your SQL blog?  I did not see a link.

Thanks,
Bobby

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia
Sent: Monday, January 30, 2006 6:44 PM
To: Access Developers discussion and problem solving; Discussion of Hardware
and Software issues; davidmcafee at gmail.com
Subject: [dba-Tech] vb script


I have a text file with unicode characters... when I open it up in notepad i
can read these characters just fine, I am running a vbscript script over it
and I noticed that when It feeds the string into a variable it just uses
some other wierd characters instead example:


         Set docString = file.OpenAsTextStream(ForReading,
TristateUseDefault)
         txtString = docString.ReadAll


the result string is:
Spindeloption liefert ein höheres Drehmoment im höheren

but the source text document shows the following string

Spindeloption liefert ein höheres Drehmoment im höheren

This is being ran from a vbscript... anybody have any idea as to why?

--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...