Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No/wrong sorting of items in bulk table editor comboboxes #703

Closed
Beep6581 opened this issue Jul 4, 2019 · 6 comments
Closed

No/wrong sorting of items in bulk table editor comboboxes #703

Beep6581 opened this issue Jul 4, 2019 · 6 comments
Labels
Milestone

Comments

@Beep6581
Copy link

@Beep6581 Beep6581 commented Jul 4, 2019

HeidiSQL 10.2.0.5599

The contents of the following comboboxes are unsorted or incorrectly sorted:

  • Change table engine
  • Change default collation
  • Convert to charset

screenshot_20190704_144615
screenshot_20190704_144855

@felixpenrose

This comment has been minimized.

Copy link

@felixpenrose felixpenrose commented Oct 23, 2019

+1 I've definitely wasted a fair amount of time trying to find utf8mb4_unicode_ci in these lists as there's very little sense to the order, and there's a lot of them to scroll through.

It would be a great help if these combo boxes could be sorted alphabetically, and would be even better if we could filter items by typing.

An example of what I mean can be seen in the select 2 JS plugin: https://select2.org/appearance

@ansgarbecker ansgarbecker added this to the v10.4 milestone Oct 23, 2019
@leeoniya

This comment has been minimized.

Copy link

@leeoniya leeoniya commented Oct 23, 2019

this looks like an overlooked case of #579

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Dec 12, 2019

Collations are sorted in the next build, while charsets need a bit more effort, as these use an internal list where the index is important to keep.

ansgarbecker added a commit that referenced this issue Dec 14, 2019
…lly, and increase height of drop down scrollbox to 16 items
@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Dec 14, 2019

Character set pulldown is now also sorted alphabetically, and moves the charsets description from left of the name to the right of it:

grafik

@Novocaine88

This comment has been minimized.

Copy link

@Novocaine88 Novocaine88 commented Dec 14, 2019

Good stuff, many thanks!

@Beep6581

This comment has been minimized.

Copy link
Author

@Beep6581 Beep6581 commented Dec 15, 2019

Thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
5 participants
You can’t perform that action at this time.