Class SQLServerTranslator

    • Field Detail

      • caseSensitivity

        protected byte caseSensitivity

        Indicate the case sensitivity to apply to each SQL identifier (only SCHEMA, TABLE and COLUMN).

        Note: In this implementation, this field is set by the constructor and never modified elsewhere. It would be better to never modify it after the construction in order to keep a certain consistency.

    • Constructor Detail

      • SQLServerTranslator

        public SQLServerTranslator()
        Builds an SQLServerTranslator which always translates in SQL all identifiers (schema, table and column) in a case sensitive manner ; in other words, schema, table and column names will be surrounded by double quotes in the SQL translation.
      • SQLServerTranslator

        public SQLServerTranslator​(boolean allCaseSensitive)
        Builds an SQLServerTranslator which always translates in SQL all identifiers (schema, table and column) in the specified case sensitivity ; in other words, schema, table and column names will all be surrounded or not by double quotes in the SQL translation.
        Parameters:
        allCaseSensitive - true to translate all identifiers in a case sensitive manner (surrounded by double quotes), false for case insensitivity.
      • SQLServerTranslator

        public SQLServerTranslator​(boolean catalog,
                                   boolean schema,
                                   boolean table,
                                   boolean column)
        Builds an SQLServerTranslator which will always translate in SQL identifiers with the defined case sensitivity.
        Parameters:
        catalog - true to translate catalog names with double quotes (case sensitive in the DBMS), false otherwise.
        schema - true to translate schema names with double quotes (case sensitive in the DBMS), false otherwise.
        table - true to translate table names with double quotes (case sensitive in the DBMS), false otherwise.
        column - true to translate column names with double quotes (case sensitive in the DBMS), false otherwise.