[IGNITE-22100] Sql. Incorrect support of character set for CHAR data type

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 24/Apr/24 12:12
• Updated: 25/Apr/24 07:23

Description

Seems the character set doesn't apply to column type.

Need to investigate the reason and fix it

For example:

// create table with LATIN-1 charset column
CREATE TABLE t_latin1 (c1 CHARACTER(3) CHARACTER SET LATIN1);

// try to insert Unicode symbol into he table
INSERT INTO t_latin1 VALUES('🍞'); -- no any error

// select from the table also return the value
SELECT * from t_latin1;
🍞

 

 

Issue Links

• Discovered while testing: IGNITE-21953 Cover SQL E021-01(Character string types. CHARACTER data type) feature by tests