[go: up one dir, main page]

Academia.eduAcademia.edu

SQL Knowledge

While writing SQL, we may sometimes need to combine our tables with other data sources. Here too, the collation (Language set) values of these different sources may be different, which may cause the query to fail. In this case, we need to call a query by synchronizing these collations with the collate command. But this causes performance loss. There is another detail when using the Collate command. Which side of the equation will we transform with collate? Here is an example. We have a table with 81 lines, which contains the average incomes of the provinces. Collation value latin1_general On the other side, we have a customer table with 3 million rows and the collation value is Turkish. Our aim is to print the average income of our customers living in that province next to the average income of each province. Does it make sense to convert Turkish value to Latin1? Converting Latin value to Turkish? Performance values are below.