[Plugin: Weekly Class Schedule] No UTF-8 support (for example, russian words looks as ?????

  • WCS version 2.0.3

    History: yesterday i’d try this plugin at first time. In my schedule there are a lot of russian words… new Classroom name looks like “?????????? ???” instead of “Спортивный зал”.

    Solution:
    1) Delete all WCS tables from DB (wp_wcs2_class, wp_wcs2_classroom, wp_wcs2_instructor, wp_wcs2_schedule)
    2) Edit plugin file: site-root/wp-content/plugins/weekly-class-schedule/includes/WcsDb.php
    at line 24: ) CHARACTER SET ‘utf8’ COLLATE ‘utf8_general_ci’;
    at line 35: ) CHARACTER SET ‘utf8’ COLLATE ‘utf8_general_ci’;
    at line 46: ) CHARACTER SET ‘utf8’ COLLATE ‘utf8_general_ci’;
    at line 63: ) CHARACTER SET ‘utf8’ COLLATE ‘utf8_general_ci’;”;
    3) Renew plugin page (if you just delete the corresponding tables).
    4) Russian, Ukrainian and other languages already supported :)))

    Table in a MySQL database created in the encoding that is assigned to the default settings. So, the fact that if the default encoding is UTF-8 Unicode character is lost, replaced by question marks.

    When creating tables in MySQL encoding should always be explicit!

    https://www.ads-software.com/extend/plugins/weekly-class-schedule/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter zhitya

    (@zhitya)

    It it another solution, without any delete/reinstall actions.
    You may to execute SQL:

    Change ###your_table_prefix### to your table prefix )))

    ALTER TABLE `###your_table_prefix###_wcs2_class’ DEFAULT CHARSET=utf8,
    MODIFY COLUMN ‘class_name’ varchar(256) CHARACTER SET utf8,
    MODIFY COLUMN ‘class_description’ TEXT CHARACTER SET utf8,
    MODIFY COLUMN ‘time_created’ varchar(50) CHARACTER SET utf8,
    MODIFY COLUMN ‘time_modified’ varchar(50) CHARACTER SET utf8;

    ALTER TABLE `###your_table_prefix###_wcs2_classroom’ DEFAULT CHARSET=utf8,
    MODIFY COLUMN ‘classroom_name’ varchar(256) CHARACTER SET utf8,
    MODIFY COLUMN ‘classroom_description’ TEXT CHARACTER SET utf8,
    MODIFY COLUMN ‘time_created’ varchar(50) CHARACTER SET utf8,
    MODIFY COLUMN ‘time_modified’ varchar(50) CHARACTER SET utf8;

    ALTER TABLE `###your_table_prefix###_wcs2_instructor’ DEFAULT CHARSET=utf8,
    MODIFY COLUMN ‘instructor_name’ varchar(256) CHARACTER SET utf8,
    MODIFY COLUMN ‘instructor_description’ TEXT CHARACTER SET utf8,
    MODIFY COLUMN ‘time_created’ varchar(50) CHARACTER SET utf8,
    MODIFY COLUMN ‘time_modified’ varchar(50) CHARACTER SET utf8;

    ALTER TABLE `###your_table_prefix###_wcs2_schedule’ DEFAULT CHARSET=utf8,
    MODIFY COLUMN ‘weekday’ varchar(32) CHARACTER SET utf8,
    MODIFY COLUMN ‘timezone’ varchar(32) CHARACTER SET utf8,
    MODIFY COLUMN ‘time_created’ varchar(50) CHARACTER SET utf8,
    MODIFY COLUMN ‘time_modified’ varchar(50) CHARACTER SET utf8;

    Thread Starter zhitya

    (@zhitya)

    It is an error with [wcs classroom=”Спортивна зала” layout=list] shortcode. ‘No Classes’ as result (((

    Developers, i need Help!

    Thread Starter zhitya

    (@zhitya)

    Why hours form contains 0,1,2,3,4,5… in 24 hour mode? Students are in the sleep-mode )))

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: Weekly Class Schedule] No UTF-8 support (for example, russian words looks as ?????’ is closed to new replies.