As before this problem in not to do with collation as Latin characters sort the same whether the collation is Latin or Chinese. The problem is your part numbers where...
This has go nothing to do with the collation it is just that when you order the parts list using standard alphanumeric ordering you get a different order to the...