I am fairly new at MySQL, so please excuse any ignorance. We are using MySQL (version 3.23.48) in connection with an Eprints archive. We have non-english deposits in the archive, and non-standard characters are not always shown right in our system. They are shown wrong in the subscription alerts that the archive generates and sends out - this is what annoys us. And they are shown wrong in the database itself. But they are shown right in the internet pages that are created based on the database.
On the Eprints support list I was adviced to check whether the characters were correctly encoded in the database. When I look in the database I see strange characters such as Jørgensen instead of Jørgensen and Schäfer instead of Schäfer (like in the email alerts). I see these strange characters whether I look in MySQL Control Center or with mysql SELECT in Putty (whether set up to see latin1 or UTF-8). But the database indicates that it uses the latin1 character set, which should be fine for the German and Danish characters we have. The email alerts are also iso-8859-1 encoded. Any ideas on what the might cause this problem? Are the non-standard characters encoded correctly in MySQL even though they look strange? If not, what can I do to correct it? Kind regards Hugo Alroe Administrator of Organic Eprints at http://orgprints.org Personal workpage: http://hugo.alroe.dk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
