[CALCITE-111] Support CONVERT function, for changing character sets

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: github-import pull-request-available
• Assignee: ZheHu
• Reporter: GitHub Import
• Created: 18/Jun/14 08:10
• Updated: 27/Jul/23 10:22
• Resolved: 20/Apr/23 04:10

Description

Support the CONVERT function, to convert strings from one character set to another.

CONVERT is defined in SQL:2011 as a feature called <character transliteration>. Here is an example:

SELECT * FROM emp WHERE CONVERT(name USING UTF16) = u&'\82f1\56fd'

The MySQL site has other examples.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/111
Created by: [julianhyde|https://github.com/julianhyde]
Labels: enhancement, 
Created at: Tue Jan 14 03:40:53 CET 2014
State: open

Issue Links

• is duplicated by: CALCITE-4014 calcite convert(column using utf8mb4) throws exception
• relates to: CALCITE-5548 Add support for MSSQL CONVERT function
• links to: GitHub Pull Request #2705