Database Reference
In-Depth Information
Choice of character set
This section explains a little-known feature—the possibility of choosing the exact
character set for our exported file.
This feature is activated by setting
$cfg['AllowAnywhereRecoding']
to
TRUE
. We
can see here the effect on the interface.
When this parameter is switched on, phpMyAdmin verifies that the conditions for
recoding are met. For the actual encoding of data, the PHP component of the web
server must support the
iconv
or the
recode
module. If this is not the case and the
parameter has been set to
TRUE
, the following error message will be generated:
Couldn't load the iconv or recode extension needed for charset conversion.
Either configure PHP to enable these extensions or disable charset conversion
in phpMyAdmin.
If this message is displayed, consult your system's documentation (PHP or the
operating system) for the installation procedures.
Another parameter (
$cfg['RecodingEngine']
) specifies the actual recoding
engine—the choices being
auto
,
iconv
, and
recode
. If it is set to
auto
,
phpMyAdmin will first try the
iconv
module and then the
recode
module.
Kanji support
If phpMyAdmin detects the use of the Japanese language, it checks whether
PHP supports the
mb_convert_encoding()
multibyte strings function. If it does,
additional radio buttons—
export
,
import
, and
query box
— are displayed on the
following pages, so that we can choose between the
EUC-JP
and
SJIS
Japanese encodings.
Search WWH ::
Custom Search