dtle icon indicating copy to clipboard operation
dtle copied to clipboard

The character set and collation of src and dest are different for procedure/function/event in incremental copy

Open Dinosauria opened this issue 6 years ago • 1 comments

Description

The character set and collation of src and dest are different, even if character_set_server and character_set_collate are the same,dest always utf8mb4.

Steps to reproduce the issue:(Take event as an example)

  1. Create a event test1 on db1 in src
  2. Post a job for the db1 with the event test1
  3. Check test1 in dest,character set & collation are different from src, even if character_set_server and character_set_collate are the same in src & dest

Describe the results you received: Check test1 in dest,character set & collation are different from src, even if character_set_server and character_set_collate are the same in src & dest

Describe the results you expected:

Output of ./dtle version:

Dtle 9.9.9.9 (git: master ea8483db80155ce736935029ff27c8362e677b02)

Additional information you deem important (e.g. issue happens only occasionally):

Additional details (log, config, job config etc):

  1. event image
  2. function image
  3. procedure image image

Dinosauria avatar Nov 15 '18 03:11 Dinosauria

trigger act the same way image

ColdWaterLW avatar Feb 03 '21 10:02 ColdWaterLW