I have data from 2 different databases, which i need to consolidate and compare which each other. An example: select distinct CustomerNo from DB1.dbo.TableCustomers UNION ALL select distinct CustNo …
Tag: collation
How to set collation of a column with SQL?
Originally, I created my SQL Server database on a local computer. I set its collation to Latin1_General_CI_AI and everything worked well. When I moved the finished work to the web hosting SQL Server, I encountered problem: they use a different database collation. So what can I do now? To be more specific, I need Latin1_General_CI_AI, but they have Czech_CI_AS. These
A script to change all tables and fields to the utf-8-bin collation in MYSQL
Is there a SQL or PHP script that I can run that will change the default collation in all tables and fields in a database? I can write one myself, but I think that this should be something that readily available at a site like this. If I can come up with one myself before somebody posts one, I will