The TRANSLATE function changes the representation of a character string from one base character set to another character set and collation.

Format: TRANSLATE(value, USING translation_char_name)

> Access does not support TRANSLATE.

> DB2 does not support the TRANSLATE standard. It has TRANSLATE(source, replacement, match).

> MySQL does not support TRANSLATE. Instead, it uses the CONV function.

> Oracle supports the TRANSLATE standard, but it can only convert between the database character set and the national language character set.

> PostgreSQL does not support TRANSLATE. Instead, it uses its own non-standard TRANSLATE function.

> SQL Server does not support TRANSLATE. Instead, it uses its own non-standard CONVERT function.