Vertica default collation ?
I have the following table in MYSQL that I need to move to Vertica.
CREATE TABLE
report_episode_detail
(
Filter_ID INT,
Member_ID VARCHAR(50) COLLATE utf8_bin,
Master_Episode_ID VARCHAR(255) COLLATE utf8_bin
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
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.