...
Access Level: Any tester can run this test
Test Description: The smartsite-test database server was recently updated to convert long text fields to a different format. This new format enhances performance by allowing Oracle to shrink space for reclamation and to allow the fields to be searched more easily.
The update affects the following tools: Announcements, Assignments, Calendar, Chat Room, Discussion Forum, Email Archive, and Resources.
Test Steps
To test this update, you simply need to verify that each of these tools still work and are unaffected by the database change.
Test for SAK-598
SAK-598: Convert SmartSite production database to UTF-8 character encoding
...
- Log into Smartsite-test.ucdavis.edu in one window and smartsite.ucdavis.edu in another window or tab.
- Select a tool in a course or project site that you have in common in both systems. The following steps will use Discussion Forum as an example
- Open another window or tab to the following UTF-8 Sampler website: http://www.columbia.edu/kermit/utf8.html
- Create a message (or enter data in another tool) by copying and pasting foreign language text from the sampler page. For example, copy the Greek phrase for "I can eat glass" or "????? ?????? ???????? ????? ?? ?? ???????" into both browsers.
- Keep a list of the phrase and languages you used and continue this process until you've identified 3-5 languages which are displayed correctly on test and fail on the production server, smartsite.ucdavis.edu. Failure to interpret and display properly will be indicated by upside-down "?" or by a box character.
- Keep this list so that you can repeat this test after the production server is upgraded. Your repeat test will be verification that the production server upgrade is successful.
...