Question
some special char showed incorrectly: missing mbstring PHP extension?
hi:
i have a problem with some chars showing fine in my local server but
being substituted by a question mark when viewing from the remote one
initially i had my database (created pasting texts in phpMyAdmin) with
the Latin-1 charset and changed it later to UTF-8:
mysql> alter database `mydb` DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
mysql> show create database mydb;
+----------+-------------------------------------------------------------------+
| Database | Create Database
+----------+-------------------------------------------------------------------+
| mydb | CREATE DATABASE `mydb` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------------+
chars giving problems:
left double quotation mark U+201C “
right double quotation mark U+201D ”
em dash U+2014 —
something keeping me confused is that the Mac Character Palette shows
different codes for the, apparently, same char:
Latin-1 supplement: Unicode 0093, UTF-8 C2 93
General puntuaction: Unicode 201C, UTF-8 E2 80 9C
the only thing i can guess as the source of the problem is that in the
remote server, phpMyAdmin is showing a warning:
"The mbstring PHP extension was not found and you seem to be using a
multibyte charset. Without the mbstring extension phpMyAdmin is unable
to split strings correctly and it may result in unexpected results."
is it neccessary to reinstall PHP to add the mbstring extension?
local
-----
OSX 10.4.8
PHP 5.1.6
MySQL 4.1.21-standard
phpMyAdmin 2.9.0.2
remote
-----
Linux 2.6.9-34.ELsmp (RHEL4 - PROFESSIONAL)
PHP 4.3.9
MySQL 4.1.12
phpMyAdmin 2.9.0.2
tia,
jdoe
i have a problem with some chars showing fine in my local server but
being substituted by a question mark when viewing from the remote one
initially i had my database (created pasting texts in phpMyAdmin) with
the Latin-1 charset and changed it later to UTF-8:
mysql> alter database `mydb` DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
mysql> show create database mydb;
+----------+-------------------------------------------------------------------+
| Database | Create Database
+----------+-------------------------------------------------------------------+
| mydb | CREATE DATABASE `mydb` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------------+
chars giving problems:
left double quotation mark U+201C “
right double quotation mark U+201D ”
em dash U+2014 —
something keeping me confused is that the Mac Character Palette shows
different codes for the, apparently, same char:
Latin-1 supplement: Unicode 0093, UTF-8 C2 93
General puntuaction: Unicode 201C, UTF-8 E2 80 9C
the only thing i can guess as the source of the problem is that in the
remote server, phpMyAdmin is showing a warning:
"The mbstring PHP extension was not found and you seem to be using a
multibyte charset. Without the mbstring extension phpMyAdmin is unable
to split strings correctly and it may result in unexpected results."
is it neccessary to reinstall PHP to add the mbstring extension?
local
-----
OSX 10.4.8
PHP 5.1.6
MySQL 4.1.21-standard
phpMyAdmin 2.9.0.2
remote
-----
Linux 2.6.9-34.ELsmp (RHEL4 - PROFESSIONAL)
PHP 4.3.9
MySQL 4.1.12
phpMyAdmin 2.9.0.2
tia,
jdoe
AdChoices