List:General Discussion« Previous MessageNext Message »
From:James Sherwood Date:August 16 2005 12:25pm
Subject:Re: French Characters, Still no answer
View as plain text  
Sorry, dont know how I missed: http://lists.mysql.com/mysql/187794

The old msql was 4.0 and the new one is 4.1.

When we first imported the data the database was in latin1(my mistake) and
we put it into production as everything seemed to work fine.

We have one site that uses french characters sometimes and they compained 1
week later.  By that time it was too late to roll back so now we have this
problem.

We tried converting the database over to Utf8 but it did not seem to fully
work.

We can put the french characters in, even from the tomcat server, but when
they come back out to the webpage(we have a content management system) they
are garbled.

One night we did some testing and hooked the tomcat to the old database and
everything worked fine with french characters so it has to be the new
database.

If no one has anymore ideas I think our best route is to dump it, install
4.0 on this server and import it back in.

Everything looks ok as far as Utf8 on the tables and such, I feel that we
are just missing one key thing that is garbling the characters.

Also when we use EMS mysqlmanager to view the data, it is fine, it is only
when it comes back to the tomcat server it seems.

Thanks for your ideas thus far,
James


----- Original Message ----- 
From: "Gleb Paharenko" <gleb.paharenko@stripped>
To: <mysql@stripped>
Sent: Monday, August 15, 2005 1:41 PM
Subject: Re: French Characters, Still no answer


> Hello.
>
> You've already got a good answer:
>   http://lists.mysql.com/mysql/187794
>
>
> Subscribe to mysql list or use web interface. Why are you mixing latin1
> with utf8 in the same column? You can check if something is wrong with
your
> connection variables using the following statement:
>
>   show variables like '%char%';
>
> Use mysql command line client or mysql-query-browser (or other client
> software which correctly handles UTF8 data) to check if import of your
> data was performed successfully. In such a way you can localize the
> problem, and find whether it is related to Tomcat or wrong data in
> MySQL.
>
>
>
>
> >I am still having trouble with french characters if anyone has ANY ideas,
> > please help.
> >
> > We have installed the newest version of MySql and cannot get it to play
> > nice
> > with French characters.  Our older version worked fine.  The problem
> > may (or
> > may not) be that when we put the dump into the new database(yes its
> > default
> > charset is Utf8) the default character set for the table is Utf8 but
> > some
> > fields are like this:
> >
> > 'Story' longtext character set latin1 NOT NULL
> >
> > We tried linking our tomcat to the old database on the other server
> > through
> > this tomcat and everything works fine but when we link the tomcat back
> > to
> > the new database, it will not play nice with french characters. (they
> > come
> > out as outlined squares etc)
> >
> > Any ideas would be greatly appreciated
> > James
> >"James Sherwood" <jsherwood@stripped> wrote:
>
>
> -- 
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
>  / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
>        <___/   www.mysql.com
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>


Thread
French Characters, Still no answerJames Sherwood15 Aug
  • Re: French Characters, Still no answerBruce Dembecki15 Aug
  • Re: French Characters, Still no answerJames Sherwood15 Aug
  • Re: French Characters, Still no answerGleb Paharenko15 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug
    • Re: French Characters, Still no answerGleb Paharenko16 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug
    • Re: French Characters, Still no answerJason Pyeron16 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug
Re: French Characters, Still no answerAce Dimitrievski15 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug