| Subject | Re: [firebird-php] Ukrainian / English question |
|---|---|
| Author | John Jaabæk |
| Post date | 2007-05-17T17:59:33Z |
Never tried this before, but thoughts are coming at once:
It seems like you need a 'dobbel' database. Each tabell could have dobbel sets
of fields. One set for ISO-8859-1 and one collate for Ukrainien. From a
self-chosen key, you choose wich language is to be used.
You can make php-headers like:
function printHeader(){
echo <<<EOF
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta name="description" content="" />
<meta name="author" content="John H. Jaabæk" />
<meta name="keywords" content="" />
<title>datotestphp</title>
</head>
<body>
EOF;
}
with Footer like:
function printFooter(){
echo "</body>\n</html>";
}
In the basic php-program you choose i which language to use by choosing the
right headerfunction.
Hope this can give you some ideas.
John
Torsdag 17 mai 2007 19:07, skrev Didier Gasser-Morlay:
It seems like you need a 'dobbel' database. Each tabell could have dobbel sets
of fields. One set for ISO-8859-1 and one collate for Ukrainien. From a
self-chosen key, you choose wich language is to be used.
You can make php-headers like:
function printHeader(){
echo <<<EOF
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta name="description" content="" />
<meta name="author" content="John H. Jaabæk" />
<meta name="keywords" content="" />
<title>datotestphp</title>
</head>
<body>
EOF;
}
with Footer like:
function printFooter(){
echo "</body>\n</html>";
}
In the basic php-program you choose i which language to use by choosing the
right headerfunction.
Hope this can give you some ideas.
John
Torsdag 17 mai 2007 19:07, skrev Didier Gasser-Morlay:
> Hello,--
>
> I am asked by a potential customer to let him know if I could have one
> of my applications allowing Data entry in English AND Ukrainian.
>
> I have'n'got a clue on how to achieve this but after some initial
> investigations, I believe I should have my DB converted to UTF-8 and
> my HTML pages announcing the fact that the page is UTF-8
>
> I am currently using Firebird 1.5, are there any caveats ?, would I
> be better off upgrading to firebird 2.0 ?
>
> could the group point me to some reading regarding this somewhat new
> territory for me ?
>
> Are there any things I should be very aware of ? My all application is
> written using ISO-8859-1, what do I need to do to convert it to UTF 8 ?
>
> Any pointer to get me started will be greatly appreciated
>
> thanks
>
> Didier