Forum Moderators: coopster

Message Too Old, No Replies

No encoding options with phpMyAdmin

No Japanese encoding options

         

whats up skip

4:58 am on May 8, 2004 (gmt 0)

10+ Year Member



I have installed phpMyAdmin on my service at pair.com and it works, except on other hosting companies there is normally an option to select the type of encoding when importing text files. For example if you set the language to Japanese (SJIS) and then go to SQL there is an option to import with EUC or SJIS encoding.
Any ideas on this one.

coopster

4:17 pm on May 10, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I don't use phpMyAdmin, but it sounds to me like a configuration option. Have you searched the documentation [phpmyadmin.net]?

whats up skip

12:05 am on May 11, 2004 (gmt 0)

10+ Year Member



It looks to be an issue with mysql. Later versions have text file import disabled for security reasons.

I still have not got to the bottom of it though.

coopster

3:12 pm on May 11, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Although I am not a phpMyAdmin user and don't know the software, I still think it is a phpMyAdmin and/or PHP issue. The link I provided has some config options that specifically refer to character set conversion parameters and their availability based on how PHP was compiled/installed. Have a look at the five configuration options beginning with
$cfg['DefaultCharset']
. You may be able to track things back from there.