1. Do \s from the mysql client to be sure its using the character set you told it to use with default-character-set=latin1. Be sure its the same one you used on your old server.
2. Since you have the Norwegian keyboard set up try typing Norwegian characters in the terminal. If they are displayed as expected then you know that the terminal font is not the problem. Having an improper terminal font is often the problem in cases like this.
3. Select the hex values for the characters which are not being displayed. "SELECT hex(Norwegian_column) FROM your_table;" If your old system is still available compare these values to the working system, just to be sure your data wasn't corrupted somewhere in the transfer.
4. Test with multiple clients if possible. Such as the command line client and a php web client.
Hope this helps, Jeremy
_________________________________________________________________
Let the new MSN Premium Internet Software make the most of your high-speed experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
