469,289 Members | 2,330 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,289 developers. It's quick & easy.

Reading data from unicode file

Hi all

I have CSV text file having unicode data in. When I am trying to insert that
data in Database using FSO it change the data.
When I copy and paste data in DB it looks ok.

set FSObj = server.CreateObject("Scripting.FileSystemObject")
Set myFile = FSObj.OpenTextFile(strFilePath,1, False,TristateTrue )

Please advise.

Kind Regards,
Jul 22 '05 #1
2 1140
are you defining TristateTrue somewhere?

put "option explicit" at the top of your code as in:

<%@ Language=VBScript %>
<%
option explicit
--
Mark Schupp

"FaYYaZ" <ne**@microsoft.com> wrote in message
news:Om**************@TK2MSFTNGP14.phx.gbl...
Hi all

I have CSV text file having unicode data in. When I am trying to insert that data in Database using FSO it change the data.
When I copy and paste data in DB it looks ok.

set FSObj = server.CreateObject("Scripting.FileSystemObject")
Set myFile = FSObj.OpenTextFile(strFilePath,1, False,TristateTrue )

Please advise.

Kind Regards,

Jul 22 '05 #2
Thanks for your reply, I do have these things defined on top.
"Mark Schupp" <no****@nospam.com> wrote in message
news:eG*************@TK2MSFTNGP15.phx.gbl...
are you defining TristateTrue somewhere?

put "option explicit" at the top of your code as in:

<%@ Language=VBScript %>
<%
option explicit
--
Mark Schupp

"FaYYaZ" <ne**@microsoft.com> wrote in message
news:Om**************@TK2MSFTNGP14.phx.gbl...
Hi all

I have CSV text file having unicode data in. When I am trying to insert

that
data in Database using FSO it change the data.
When I copy and paste data in DB it looks ok.

set FSObj = server.CreateObject("Scripting.FileSystemObject")
Set myFile = FSObj.OpenTextFile(strFilePath,1, False,TristateTrue )

Please advise.

Kind Regards,


Jul 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jessard | last post: by
5 posts views Thread by Jamie | last post: by
3 posts views Thread by Sivaraj G via .NET 247 | last post: by
11 posts views Thread by Freddy Coal | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.