WordPress.org

Ready to get started?Download WordPress

Forums

Weekly Class Schedule
No UTF-8 support (for example, russian words looks as ????? (4 posts)

  1. zhitya
    Member
    Posted 1 year ago #

    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!

    http://wordpress.org/extend/plugins/weekly-class-schedule/

  2. zhitya
    Member
    Posted 1 year ago #

    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;

  3. zhitya
    Member
    Posted 1 year ago #

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

    Developers, i need Help!

  4. zhitya
    Member
    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic