does anyone know how to accomplish the following? I currently have a mysql db table where the default character set for the character columns is LATIN1.
Currently I have French words including : Fraîcheur - notice the "î" I currently do a dump of the table via php that prepares a sql insert statement so that data can be loaded into another mysql database, which also has a LATIN1 character set for the destination table. HOWEVER - as this destination table is for an english speaking user, I need to translate the french letters to their english equivelant via my php script. Can this be done? The character set is the same on both the target and source tables. One other issue is that, depending on the tool I use to import the text file values, sometimes the letters are LOST entirely, and produce a "?" where the letter should go. this is an annoyance, but also another reason to move the english version of the letters. THANKS for your help
