LoadUSPTOPAD.sql
To get the data into UTF-8ASCII or ASCII, move it to the dbase server then:
*Check its encoding using:
file -i Car.java
chmod +x encoding.sh
./encoding.sh
*Note that the final source encoding was Win1252 and the final target encoding was ASCII
*All bar three of the files had to be manually fixed to remove errors. Final files are in E:\McNair\Projects\USPTO Patent Assignment Dataset