[
https://issues.apache.org/jira/browse/IGNITE-22100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-22100:
----------------------------------------
Description:
Seems the character set doesn't apply to column type.
Need to investigate the reason and fix it
For example:
{code:java}
// 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;
🍞{code}
was:
Seems the character set doesn't apply to column type.
Need to investigate the reason and fix it
For example:
{code:java}
// 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;
🍞{code}
> Sql. Incorrect support of character set for CHAR data type
> ----------------------------------------------------------
>
> Key: IGNITE-22100
> URL: https://issues.apache.org/jira/browse/IGNITE-22100
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> Seems the character set doesn't apply to column type.
> Need to investigate the reason and fix it
> For example:
> {code:java}
> // 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;
> 🍞{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
