Changing Collation: Will it affect exiting VB 6.0 application?

We are migrating SQL Server 7.0 database to SQL Server 2005. I want to change collation on database and tables. I know how to do that. I would like to know if it would affect VB 6.0 application that using migrated database as a back end.
LISCNYAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
note: if all the database, tables, columns have the same collation, there should be no problem.
the only thing you might then see is different sorting/matching results, based on the data vs collation
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
it can affect, yes.
if it will affect, only full regression tests can prove that.
0
 
LISCNYAuthor Commented:
Thank you.
0
 
LISCNYAuthor Commented:
It was helpful
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.