Loosing é characters in DB insertion

2003-11-07 Thread Yves Arsenault
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

RE: Loosing é characters in DB insertion

2003-11-07 Thread Victor Pendleton
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

RE: Loosing é characters in DB insertion

2003-11-07 Thread Yves Arsenault
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

RE: Loosing é characters in DB insertion

2003-11-07 Thread Victor Pendleton
: 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

RE: Loosing é characters in DB insertion

2003-11-07 Thread Yves Arsenault
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

RE: Loosing é characters in DB insertion

2003-11-07 Thread Victor Pendleton
] 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

RE: Loosing é characters in DB insertion

2003-11-07 Thread Yves Arsenault
The only language I installed on this box is English... would that be why? Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 14:16 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing é characters in DB insertion The Red Hat