Selected collating sequence not supported by the Operating system. This problem is because the system of the foreign server is the English system . So the Access database has gone wrong with Chinese. The specific solution is this. 1), open my Microsoft Access, opening any file, then click Tools, select Options, and then select General. Notice the New Database Sort order drop-down box at the bottom right, and select General. Then turn off the file. (Note that options can only be used if a file is open) 2), and then "file"--"New ..." Create a blank data file, and then "file"--"Get External Data"--"Import", open my old database file to upload all the tables to the new file, and then save the new file. I'm going to do this because there's a lot of data in my forum, and I don't want to start all over again. If you encounter such problems when you create a new forum or create a new system, you can create a new table, or write the initial data with SQL query. 3), save the new file, and then upload it to the server. 4), Done! |
ASP ACCESS Error: Selected collating sequence not supported by the operating system.