We hardcoded our collation so that we new the database was set up exactly as we wanted it. I think potentially you should ensure that your application can run succesfully under different collations, so taking care with your queries and updates to ensure they always return the same results regardless of collation, but for us this would have meant a massive extra overhead in testing.

The issue can be that you cannot run queries across separate database that have different collations, well you can by using the COLLATE function in the SQL but you have to tell the SQL what collation to use.

Regards

Jon


>Hi,
>Thank you
>
>1. Is it a good practise if we hardcoded the collation in our create/upgrade db sql script?
>2. Would collation affect VFP application ?
>
>Thank you