> The problem is, when I get the data from the database via a > webpage (php) everything works as expected. The problem is when I > try to get the results from the mysql client (ie. SELECT body FROM > thread WHERE tid=30) the national accented characters are shown as > "?". I have browsed through the manual and stumbled upon this one:
When connecting through php I get: character_set_client: latin2 character_set_connection: latin2 character_set_database: latin2 character_set_results: latin2 character_set_server: latin2 character_set_system: utf8 character_sets_dir: /usr/local/share/mysql/charsets/ collation_connection: latin2_general_ci collation_database: latin2_general_ci collation_server: latin2_general_ci Could someone tell me how to set all those parameters for mysqldump? Unfortunately -O does not work as expected: [EMAIL PROTECTED] martel]$ mysqladmin -O character_set_results=latin2 mysqladmin: ERROR: unknown variable 'character_set_results=latin2' -- Martel Valgoerad (a.k.a. Michal Minicki) | "I am not young enough to know alea.iacta.est | Martel --> [EMAIL PROTECTED] | everything." Oscar Wilde Web Page: http://www.aie.pl | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]