Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

correct use of charset and db command

4 views
Skip to first unread message

nawfer

unread,
Dec 30, 2009, 2:25:40 PM12/30/09
to
if I have an old db maked in a system mysql4 php4 with phpmyadmin command:
"my-name-db1" "collation"
and MySQL connection collation "utf8_general_ci"

I see that inner the folder there is a file db with this row:
default-character-set=latin1
default-collation=latin1_swedish_ci

if I want copy on system mysql5 php5 which are the correct steps?
I does so (seem work, but not sure of the procedure)
Creted a new db:
"my-name-db2" "collation"
and MySQL connection collation "utf8_general_ci"

and import the file sql created by phpadmin
with option Character set of the file: "latin1" here think must tuo use
utf8 was better


I make so but which is the correct solution?

other: is possible to change the old db in new that have
default-character-set=utf8 default-collation=utf8_unicode_ci ?
how and there are problems?

is this the correct settings for all the new db that one will create?

-----------
I noticed that there is also this version of phpmyadmin
phpMyAdmin-2.11.10-all-languages-utf-8-only when is better to use respect
at phpMyAdmin-2.11.10-all-languages;

why for phpmyadmin 3.x there isn't this version (.........utf-8-only)?
-----------

thanks for all suggestions;
really useful


Jerry Stuckle

unread,
Dec 30, 2009, 4:43:41 PM12/30/09
to

This has nothing to do with PHP. Try an appropriate newsgroup such as
comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

0 new messages