DBF file with Thai Characters

  • Hi

    I have been given a number of dbf files to import into sql tables..

    I am using SSIS 2008 to do the import and all works fine except some of the files have columns that sometimes can contain Thai characters (ie Stock Description)

    I have tried changing the codepage to 874 and localeID to 1054 but still no result...

    I can use a 'Simple DBF Viewer' program to view the file and the Thai characters display fine???

    Any assistance appreciated.. I can supply a sample file if needed.

    Cheers

    Graham

  • graham 47698 (7/17/2011)


    Hi

    I have been given a number of dbf files to import into sql tables..

    I am using SSIS 2008 to do the import and all works fine except some of the files have columns that sometimes can contain Thai characters (ie Stock Description)

    I have tried changing the codepage to 874 and localeID to 1054 but still no result...

    I'm a total newb in this area, but would COLLATION settings have something to do with this?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • I've tried different collation setting also :unsure:

    Now looking at changing the DBF copepage using CPZERO.PRG within Foxpro..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply