Here are three ways to return the collation of a column in MariaDB.
how to
Set the Character Set and Collation of a Table in MariaDB
You can specify the character set and collation at various levels in MariaDB. You can specify them at the connection level, the server level, the database level, the table level, and even the column level.
You can also specify a collation in your queries so that it overrides any collation that has been previously specified at the aforementioned levels.
To set the character set and collation at the table level, use the CREATE TABLE statement or ALTER TABLE statement (depending on whether you’re creating the table or modifying it).
4 Ways to Get the Database Collation in MariaDB
Here are four ways to return the database collation in MariaDB.
How SHOW COLLATION Works in MariaDB
In MariaDB, you can use the SHOW COLLATION administrative SQL statement to return all available collations in MariaDB.
Show the Collation in MariaDB
In MariaDB, collation can be applied at many levels. Collation can be applied at the server level, the connection level, the database level, the table level, and even at the column level.
It’s also possible to specify a collation at the query level, so that it will override any collation that has been applied at the database, table, or column levels.
MariaDB provides a number of options for returning the collation at the various levels.
3 Ways to Remove a Value from an Array in MongoDB
MongoDB provides a few operators that enable you to remove values from arrays.
These include:
$pull$pullAll$pop
Return the Partition Number for Each Row When Querying a Partitioned Table in SQL Server (T-SQL)
If you’ve got a partitioned table in SQL Server, and you now want to run a query that includes the partition number on each row returned by the query, you can use the $PARTITION system function to do just that.
The $PARTITION function returns the partition number into which a set of partitioning column values would be mapped for any specified partition function.
You can therefore use it in your SELECT statement to return the partition that each row belongs to.
How to Edit Linked Server Options using T-SQL
If you’ve previously created a linked server, but you now want to update one or more of its server options, you can do that either via the SQL Server Management Studio GUI or with T-SQL.
If you choose to do it with T-SQL, the sp_serveroption system stored procedure is what you need.