You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/05/19 01:31:25 UTC
[GitHub] [shardingsphere] VeejaLiu opened a new issue, #17793: When using proxy to import data, there may be a character set problem
VeejaLiu opened a new issue, #17793:
URL: https://github.com/apache/shardingsphere/issues/17793
## Bug Report
### Which version of ShardingSphere did you use?
5.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
Proxy
### Error
When I import sql to proxy, there are several error with the character set.
However, I used the same method to import this data directly into mysql, but it was successful, so the probability is that the character set of proxy is the problem, not mysql.
### More
Command:
```
mysql \
-h$DB_HOST \
-u$DB_USER \
-p$DB_PASSWORD \
-P$DB_PORT \
${DB_DATABASE} \
< "$FILE"
```
Table:
```
CREATE TABLE `EMAIL_REPLY_TEAM_0` (
`email_reply_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_reply_team_id` varchar(50) NOT NULL,
`email_reply_user_id` varchar(50) NOT NULL,
`email_reply_account_id` int(10) unsigned NOT NULL,
`email_reply_candidate_id` varchar(50) NOT NULL,
`email_reply_status` tinyint(1) NOT NULL DEFAULT '0',
`email_reply_belong_sequence` int(10) unsigned NOT NULL,
`email_reply_email_thread_id` int(10) unsigned DEFAULT NULL,
`email_reply_schedule_utc_timestamp` bigint(20) NOT NULL,
`email_reply_schedule_date` varchar(100) NOT NULL,
`email_reply_schedule_timezone` varchar(100) DEFAULT NULL,
`email_reply_subject` varchar(191) DEFAULT NULL,
`email_reply_sender` text NOT NULL,
`email_reply_receiver` text NOT NULL,
`email_reply_cc` text,
`email_reply_bcc` text,
`email_reply_body` text,
`email_reply_in_reply_to` varchar(191) DEFAULT NULL,
`email_reply_reply_to_message_id` varchar(191) DEFAULT NULL,
`email_reply_reply_to_thread_id` varchar(191) DEFAULT '',
`email_reply_file_ids` varchar(2000) DEFAULT NULL,
`email_reply_reminder` int(11) DEFAULT NULL,
`email_reply_type` tinyint(1) NOT NULL DEFAULT '0',
`email_reply_project_id` int(11) DEFAULT NULL,
`email_reply_track_open` tinyint(1) NOT NULL DEFAULT '1',
`email_reply_track_link` tinyint(1) NOT NULL DEFAULT '1',
`email_reply_source` tinyint(1) NOT NULL DEFAULT '0',
`email_reply_extra` text,
`email_reply_update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`email_reply_create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`email_reply_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] VeejaLiu closed issue #17793: When using proxy to import data, there may be a character set problem
Posted by GitBox <gi...@apache.org>.
VeejaLiu closed issue #17793: When using proxy to import data, there may be a character set problem
URL: https://github.com/apache/shardingsphere/issues/17793
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] VeejaLiu commented on issue #17793: When using proxy to import data, there may be a character set problem
Posted by GitBox <gi...@apache.org>.
VeejaLiu commented on issue #17793:
URL: https://github.com/apache/shardingsphere/issues/17793#issuecomment-1131050574
@TeslaCN I have solved this problem by adding connected character sets. Thank you for your help!!!
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #17793: When using proxy to import data, there may be a character set problem
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17793:
URL: https://github.com/apache/shardingsphere/issues/17793#issuecomment-1131042956
Have you try the solution in #13023?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org