writing foreign language chars from php5 to db (mysql4)
| From: | Louie Miranda | Date: | Mon, 15 Aug 2005 02:21:43 +0000 |
| Subject: | writing foreign language chars from php5 to db (mysql4) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40072@lists.php.net to get a copy of this message | ||
Does anybody knows how to insert a foreign lang. char into php5 to mysql4?
languages, ex:
- japanese (jis)
- german (de)
I now know, how to display it properly on a website using meta tags.
ex:
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
And catching it over a php5 form.
But, when i insert it to a db. Everything's messed up.
// code
$languagechar = $_GET["languagechar"];
$insert = "
INSERT INTO languages
(
char)
values
('$languagechar')
";
$add_member = $dbData->query($insert);
if (DB::isError($add_member)) {
die($add_member->getMessage());
}
// code
Do i need to convert it to something? Im testing it my phpmyadmin, and
phpmyadmin can insert it with the correct values and characters. How come on
my code it does not.
--
Louie Miranda
http://www.axishift.com -- under development