The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica default collation ?

I have the following table in MYSQL that I need to move to Vertica.
Filter_ID INT,
Member_ID VARCHAR(50) COLLATE utf8_bin,
Master_Episode_ID VARCHAR(255) COLLATE utf8_bin

DO I need to worry in Vertica to COLLATE the fields being the fact that that default is default [email protected]=binary?

As shown here
Locale specifies the user's language, country, and any special variant preferences, such as collation. Vertica uses locale to determine the behavior of certain string functions. Locale also determines the collation for various SQL commands that require ordering and comparison, such as aggregate GROUP BY and ORDER BY clauses, joins, and the analytic ORDER BY clause.

The default locale for a Vertica database is [email protected]=binary (English US). You can define a new default locale that is used for all sessions on the database. You can also override the locale for individual sessions. However, projections are always collated using the default [email protected]=binary collation, regardless of the session collation. Any locale-specific collation is applied at query time.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file