Collation

  • Resolved schneemann

    (@schneemann)


    7 years, 10 months ago

    Dear Tobias,
    first of all, as all precedessors, Your plugin works pretty well! There is only a small problem, and its called “collation”.
    What do I mean: providing I have a Tablepress table with national-specific characters. In our case Czech accents (?,?,? etc.).
    Such table can be sorted with arrows in editing process – but problem is, that it is actually done by standard English 24 letter alphabet.
    (For example, ascending sequence should be c,?,r,?,…and not x,y,z,?,?.(
    We thought, that it could be fixed by proper case insensitive collation setting on wp_posts table. But since every tablepress table content is physically stored just in one field this wont help, will it?
    Is there any solution on this?

    I know, its a pain to cope with silly questions like this-)

    thanks anyway!

    Deployment infos are:
    · Website: https://pagis.npu.cz/wordpress
    · TablePress: 1.7
    · TablePress (DB): 32
    · TablePress table scheme: 3
    · Plugin installed: 2016/08/15 16:53:02
    · WordPress: 4.6.1
    · Multisite: no
    · PHP: 5.6.28
    · mysqli Extension: true
    · mySQL (Server): 5.5.53-MariaDB
    · mySQL (Client): mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
    · ZIP support: yes
    · UTF-8 conversion: yes
    · WP Memory Limit: 40M
    · Server Memory Limit: 256M
    · Magic Quotes: off
    · WP_DEBUG: false
    · WP_POST_REVISIONS: true

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    No, I don’t think that setting a different collation on the wp_posts table will do anything here. I think it’s best to leave this at the WordPress default values.
    TablePress stores the tables as JSON-encoded arrays in just one field. UTF-8 characters are encoded as well.

    The sorting on both the frontend and the “Edit” screen use JavaScript, this has nothing to do with the collation. If the sorting there is not what you want, I suggest to export the table to a .csv file, open that in Excel, sort the table there (hoping that Excel sorts it correctly), and re-import the .csv file, choosing to replace the existing table.

    Regards,
    Tobias

    Thread Starter schneemann

    (@schneemann)

    Thanks for prompt answer Tobias.
    I thought so:-(
    I wondered if there was any way to change JavaScripts sorting (Intl.Collator?)…but I realize thats probably impossible to customize code for various languages at once.
    I bypassed this by adding another attribute and then order table by this (c,cz etc.).
    It is clumsy solutiona bit, but it works:-)
    Thanks anyway!
    S.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no, I’m not aware of changing everything for the various languages. Your approach is the best for this scenario, I think.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Collation’ is closed to new replies.