Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
Hi. I have a problem with the dump and character set - it would be great if someone could help. I have created a database and my tables a long time ago when the database was a the 4.0 version. Yet some time ago, my server admin has upgraded the server to version 4.1.2. I haven't noticed that

Re: Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
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

Re: Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
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