Revision history for UTF8DatabaseCollation
Revision [23381]
Last edited on 2016-05-20 07:38:47 by MartinMisuth [Replaces old-style internal links with new pipe-split links.]Additions:
For the later to be addressed maybe all the string related functions in wikka need to change to their [[http://php.net/manual/en/ref.mbstring.php | multibyte string]] relatives (i.e. strtolower -> mb_strtolower) but it seems too much to do.
Deletions:
Additions:
2. change encoding in ''actions/header.php'' or ''templates/header.php'' (for wikka 1.1.6.5+) to UTF-8 instead of ISO-8859-1
3. modify function **Query**
**for v1.1.6.2**, modify function **Query** in ''libs/Wakka.class.php'', on line 41 inserted a line
**for v1.1.6.5+**, search for and modify **Query** function ''libs/Wakka.class.php'', on line 80 and 86 inserted a line
%%(php;72)
function Query($query, $dblink='')
// init - detect if called from object or externally
if ('' == $dblink)
{
$dblink = $this->dblink;
$object = TRUE;
mysql_query("SET NAMES 'utf8'"); // ET: added for utf-8 support
$start = $this->GetMicroTime();
}
else
{
$object = FALSE;
mysql_query("SET NAMES 'utf8'"); // ET: added for utf-8 support
}
3. modify function **Query**
**for v1.1.6.2**, modify function **Query** in ''libs/Wakka.class.php'', on line 41 inserted a line
**for v1.1.6.5+**, search for and modify **Query** function ''libs/Wakka.class.php'', on line 80 and 86 inserted a line
%%(php;72)
function Query($query, $dblink='')
// init - detect if called from object or externally
if ('' == $dblink)
{
$dblink = $this->dblink;
$object = TRUE;
mysql_query("SET NAMES 'utf8'"); // ET: added for utf-8 support
$start = $this->GetMicroTime();
}
else
{
$object = FALSE;
mysql_query("SET NAMES 'utf8'"); // ET: added for utf-8 support
}
Deletions:
3. modify function Query
**for v1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
No Differences
Additions:
**for v1.1.6.1**, modify ''wikka.php'', on line 88 inserted a line
**for v1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
**for v1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
Deletions:
**for v1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
Additions:
With wikka 1.1.6.1 release
**for v1.1.6.1**, modify ''wikka.php'', on line 88 inserted a line
**for v1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
**for v1.1.6.1**, modify ''wikka.php'', on line 88 inserted a line
**for v1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
Deletions:
**for 1.1.6.1**, modify ''wikka.php'', on line 88 inserted a line
**for 1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
No Differences
Additions:
1. Change Collation of ''wikka_pages.body'' and tag field to UTF8_bin using PhpMyAdmin
2. change ''actions/header.php'' to UTF-8 instead of ISO-8859-1
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
3. modify function Query
**for 1.1.6.1**, modify ''wikka.php'', on line 88 inserted a line
**for 1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
%%(php;37)
2. change ''actions/header.php'' to UTF-8 instead of ISO-8859-1
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
3. modify function Query
**for 1.1.6.1**, modify ''wikka.php'', on line 88 inserted a line
**for 1.1.6.2**, modify ''libs/Wakka.class.php'', on line 41 inserted a line
%%(php;37)
Deletions:
2. change actions/header.php to UTF-8 instead of ISO-8859-1
**modified**
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
3. modify wikka.php, on line 88 inserted a line
Additions:
**modified**
Deletions:
No Differences
Additions:
**original**
**modified**
**original**
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
**modified**
**modified**
**original**
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
**modified**
Deletions:
**modified**
Additions:
2. change actions/header.php to UTF-8 instead of ISO-8859-1
**original**
%%(php;1)
<?php
$message = $this->GetRedirectMessage();
$user = $this->GetUser();
**modified**
<?php
header('Content-type: text/html; charset=UTF-8');
$message = $this->GetRedirectMessage();
$user = $this->GetUser();
**original**
%%(php;1)
<?php
$message = $this->GetRedirectMessage();
$user = $this->GetUser();
**modified**
<?php
header('Content-type: text/html; charset=UTF-8');
$message = $this->GetRedirectMessage();
$user = $this->GetUser();
Deletions:
Revision [13196]
Edited on 2006-02-15 06:40:28 by GiorgosKontopoulos [Modified links pointing to docs server]Additions:
===UTF-8 solution to Internationalization (avoid - it has side effects)===
Here is a solution:
Here is a solution:
Deletions:
Here is a **solution** (look at [[http://xiosweb.com/wikka/SandBox SandBox]] for example)