Reading data from unicode file

Discussion in 'ASP General' started by FaYYaZ, May 3, 2005.

  1. FaYYaZ

    FaYYaZ Guest

    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,
    FaYYaZ, May 3, 2005
    #1
    1. Advertising

  2. FaYYaZ

    Mark Schupp Guest

    are you defining TristateTrue somewhere?

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

    <%@ Language=VBScript %>
    <%
    option explicit


    --
    Mark Schupp



    "FaYYaZ" <> wrote in message
    news:Oman8Q$...
    > 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,
    >
    >
    Mark Schupp, May 3, 2005
    #2
    1. Advertising

  3. FaYYaZ

    FaYYaZ Guest

    Thanks for your reply, I do have these things defined on top.


    "Mark Schupp" <> wrote in message
    news:eGHcyp$...
    > are you defining TristateTrue somewhere?
    >
    > put "option explicit" at the top of your code as in:
    >
    > <%@ Language=VBScript %>
    > <%
    > option explicit
    >
    >
    > --
    > Mark Schupp
    >
    >
    >
    > "FaYYaZ" <> wrote in message
    > news:Oman8Q$...
    >> 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,
    >>
    >>

    >
    >
    FaYYaZ, May 3, 2005
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steve
    Replies:
    3
    Views:
    5,040
    Oliver Wong
    Sep 29, 2005
  2. Jamie

    Reading Unicode Strings from File

    Jamie, Nov 24, 2003, in forum: C Programming
    Replies:
    5
    Views:
    747
    Simon Biber
    Nov 27, 2003
  3. Jeremy
    Replies:
    1
    Views:
    801
    Alex Willmer
    Jan 11, 2011
  4. Jeremy
    Replies:
    0
    Views:
    576
    Jeremy
    Jan 11, 2011
  5. Replies:
    5
    Views:
    79
    Chris Angelico
    May 14, 2014
Loading...

Share This Page