On 10/30/06, Pythoni <[EMAIL PROTECTED]> wrote: > > Here are MySQL settings, both on Linux and XP windows > > > LINUX MySQL settings > +--------------------------+----------------------------+ > | Variable_name | Value | > +--------------------------+----------------------------+ > | character_set_client | latin1 | > | character_set_connection | latin1 | > | character_set_database | utf8 | > | character_set_results | latin1 | > | character_set_server | latin1 | > | character_set_system | utf8 | > | character_sets_dir | /usr/share/mysql/charsets/ | > > | collation_connection | latin1_swedish_ci | > | collation_database | utf8_czech_ci | > | collation_server | latin1_swedish_ci | > > > > XP Windows MySQL settings > +--------------------------+---------------------------------------------- > ------ > > | Variable_name | Value > > +--------------------------+---------------------------------------------- > ------ > > | character_set_client | latin1 > > | character_set_connection | latin1 > > | character_set_database | latin1 > > | character_set_filesystem | binary > > | character_set_results | latin1 > > | character_set_server | utf8 > > | character_set_system | utf8 > > | character_sets_dir | C:\Program Files\MySQL\MySQL Server > 5.0\share\charsets\ > +--------------------------+---------------------------------------------- > ------ > | collation_connection | latin1_swedish_ci | > | collation_database | latin1_swedish_ci | > | collation_server | utf8_czech_ci | > +----------------------+-------------------+
I think that collation_connection and collation_database take precedence over collation_server, so you are really using latin1_swedish_ci, although Django should be forcing utf8 (presumably utf8_general_ci) when it opens the connection. It also looks like your character set and collation settings are different between Linux and XP. > What command shall I use for data exporting on Linux and what command > on > XP to import > data? Your command shown previously looked OK. Was the file transferred in binary mode? (If that's even applicable.) -- This message has been scanned for memes and dangerous content by MindScanner, and is believed to be unclean. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
