MantisBT - ATutor
View Issue Details
0002247ATutor- no cat -public2005-12-06 08:422008-08-21 08:59
user2 
greg 
highminoralways
closedfixed 
 
1.6 
SVN
0002247: utf8
more info on utf8 and how php doesn't support it very well.

http://www.phpwact.org/php/i18n/utf-8 [^]

http://www.phpwact.org/php/i18n/charsets [^]

very few options till php 6.

How dokuwiki deals with it: (checks for mb first, then does it manually)
http://dev.splitbrain.org/view/darcs/dokuwiki/inc/utf8.php [^]
No tags attached.
related to 0002108closed greg Multibyte string issues 
zip norwegian_course_27_Aug_07.zip (2,064) 2007-09-05 07:16
http://www.atutor.ca/atutor/mantis/file_download.php?file_id=38&type=bug
Issue History
2005-12-06 08:42user2New Issue
2005-12-06 10:11user2Relationship addedrelated to 0002108
2006-09-07 07:48user2Note Added: 0002176
2007-01-08 06:10user2Note Added: 0002266
2007-01-08 06:10user2Affects version => SVN
2007-01-08 06:10user2Prioritynormal => high
2007-03-16 09:21user2Note Added: 0002375
2007-03-19 07:10user2Note Added: 0002379
2007-03-19 10:55user2Note Added: 0002383
2007-03-19 11:47user2Note Edited: 0002383
2007-03-20 06:31user2Description Updated
2007-03-21 05:59user2Note Added: 0002385
2007-07-06 06:48user2Note Added: 0002477
2007-07-13 10:28user2Note Added: 0002496
2007-07-26 09:48user2Note Added: 0002506
2007-09-05 07:16gregFile Added: norwegian_course_27_Aug_07.zip
2007-12-08 13:05gregStatusnew => resolved
2007-12-08 13:05gregFixed in Version => 1.6
2007-12-08 13:05gregResolutionopen => fixed
2007-12-08 13:05gregAssigned To => greg
2007-12-08 13:05gregNote Added: 0002581
2008-08-21 08:59gregStatusresolved => closed

Notes
(0002176)
user2   
2006-09-07 07:48   
next major version of atutor should require mysql 4.1.16 to make the utf8 transition easier.
(0002266)
user2   
2007-01-08 06:10   
for mysql5 support need to run mysql_query('SET CHARACTER SET latin1', $db); for every connection.
(0002375)
user2   
2007-03-16 09:21   
discussion:
http://mysqldump.azundris.com/archives/60-Handling-character-sets.html [^]
(0002379)
user2   
2007-03-19 07:10   
move all php string truncation to mysql.
(0002383)
user2   
2007-03-19 10:55   
(edited on: 2007-03-19 11:47)
places where substring is used that would cause a problem with unicode:

inbox/send_message.php
themes/default/test_questions/matching_stats.tmpl.php
themes/default/test_questions/ordering_stats.tmpl.php
themes/default/test_questions/multichoice_stats.tmpl.php
tools/tests/questions.php
tools/glossary/index.php
include/header.inc.php
include/html/tests_questions.inc.php
include/html/forum.inc.php
include/html/dropdowns.glossary.inc.php
include/lib/search.inc.php
include/classes/ContentManager.class.php
forum/new_thread.php
admin/language_editor.php

glossary/index.php

a few strlen issues not related to above (also a problem when using on binary data):
registration.php
file_storage/edit.php
file_storage/new.php
admins/my_password.php
include/classes/zipfile.class.php

(0002385)
user2   
2007-03-21 05:59   
text (varchar) fields will have to be increased x4.
(0002477)
user2   
2007-07-06 06:48   
important note:

when converting the db fields to utf8 they must first be converted to binary and then to utf8, otherwise some text will turn into garbage.
(0002496)
user2   
2007-07-13 10:28   
get people using utf language packs in 1.5.5
then convert the tables to utf8 for 1.6 with full utf8 support and update php/mysql requirements.
(0002506)
user2   
2007-07-26 09:48   
i18n should be a part of this too? making use of php's locale settings.
(0002581)
greg   
2007-12-08 13:05   
System converted over to UTF-8