July 17, 2011 at 1:32 am
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
July 18, 2011 at 6:27 am
graham 47698 (7/17/2011)
HiI 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
July 22, 2011 at 10:33 pm
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