The Red Hat client does not display the 233 the same as the MS client. The underlying data should be the same. Try to dump the decimal values of the data in question and see if 233 is present where it is supposed to be.
-----Original Message----- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:44 AM To: Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Red Hat 9. Looking at the data through Webmin, it appears as though the text is correct in the DB in certain fields, in some others, there are strange characters... I think the clients db may have had slight errors... In any effect, the web interface that is run off this DB doesn't display the 'é' characters.. Yves -----Original Message----- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:29 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion What operating system does the MySQL server reside? The ASCII representation for é is 233. Is this the same value for the host machine? -----Original Message----- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:27 AM To: Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion The è caracter is being changed to a square... Yves -----Original Message----- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:19 To: 'Yves Arsenault'; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Are the é being replaced by another character? -----Original Message----- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 10:05 AM To: 1Mysql Subject: Loosing "é" characters in DB insertion Hello, I just took over a site from a client, he used an Access DB, the Database contains mostly french text... I've created a dump file to transfer the DB to MySQL, but when I execute the code, the é characters are lost. They're being created as VARCHAR.. I'm not a very experienced MySQL user. Is there anything I should look for in the dump file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]