Hello,
How to install PHP utilities/modulesthat are not included in default install of XAMPP. For example, I need iconv and forceutf8, but I am not sure how to make them available.
Thanks
vvucic wrote:OK. But, how can I use PHP Library iconv?
I installed it in win and Linux machines.
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
DB="dbname"
(
echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_general_ci;'
mysql "$DB" -e "SHOW TABLES" --batch --skip-column-names \
| xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;'
) \
| mysql "$DB"
DB="dbname"; ( echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_general_ci;'; mysql "$DB" -e "SHOW TABLES" --batch --skip-column-names | xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;' ) | mysql "$DB"
vvucic wrote:So, I Guess, I have to install mysql in Linux machine, start SQL and in terminal prompt issue that command assuming that database is in the same folder so the comand can find it and be executed properly.
vvucic wrote:I tried SQL command but it did not work.
vvucic wrote:When I start it in terminal as root user I have got the following error message:.
vvucic wrote:I want to make solution like forceutf to double encoded strings that produce garbled characters .
Users browsing this forum: No registered users and 71 guests