ziya05 opened a new issue, #39453: URL: https://github.com/apache/doris/issues/39453
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.12 ### What's Wrong? when I load a data file into a data with "load data local infile", If the file has chinese, after loaded, querying is incorrect, the first column data is truncated. ### What You Expected? the result of querying is correct, the first column data won't be truncated. ### How to Reproduce? my table like below: create table testdb.test_data ( id varchar(15) comment "id", score decimal(6, 3) comment "平均成绩", kind varchar(50) comment "分类", name varchar(100) comment "名字" ) unique key(id) DISTRIBUTED by hash(`id`) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 3" ); and data like below: id,score,kind,name 1005458303,30.109,02,这是第一人 1005458404,30.012,02,这是第二人 1005458512,30.109,02,这是第三人 1005458616,30.012,02,这是第四人 1006242961,30.423,03,这是第五人 1006242971,30.049,03,这是第六人 1006245411,30.401,02,这是第七人 then load data: load data local infile 'test.txt' into table test_data columns terminated by ',' lines terminated by '\n'; then query data:  ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
