General information
Forum:
Microsoft SQL Server
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only