"Fossies" - the Fresh Open Source Software Archive

Member "phplist-3.5.0/doc/README.utf8" (14 Jan 2020, 694 Bytes) of package /linux/www/phplist-3.5.0.tgz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 
    2 
    3 2011-01-17 - MD
    4 
    5 UTF-8 conversion, some notes
    6 
    7 as from around now, code is changed to force everything into UTF-8
    8 
    9 to handle this in the DB, the tables need converting
   10 
   11 clean empty DB -> initialise will create them using UTF-8
   12 
   13 existing DB -
   14 
   15 run admin/?page=converttoutf8
   16 
   17 this will take the existing tables and set any that are not UTF-8 to become UTF-8
   18 seems to work fairly ok, but fails on key over 1000 and data in DB data is still scrambled, when text has been entered
   19 with UTF-8
   20 
   21 to convert the DB as well, the following can be done:
   22 
   23 mysqldump database > database-preutf8.sql 
   24 iconv -f iso-8859-1 -t utf-8 database-preutf8.sql  > database-utf8.sql
   25 mysql database < database-utf8.sql
   26