Still no answer, perhaps, but ther'es still no question.

Per my earlier response What version of MySQL is the old version
you refer to, what version is the new version you refer to? With that
information someone here is more likely to be able to tell you
something useful without that you're not likely to get much of a
response.

Best Regards, Bruce

Aug 15, 2005, at 7:59 AM, James Sherwood wrote:

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. 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 NT 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

The older version is 4.xx.xx im not sure how to tell.

New version is 4.1.12

Thank you,
James

Message
From: "Bruce Dembecki" <bruce (AT) liveworld (DOT) com>
To: "James Sherwood" <jsherwood (AT) rgisolutions (DOT) com>
Cc: <mysql (AT) lists (DOT) mysql.com>
Sent: Monday, August 15, 2005 2:50 PM
Subject: Re: French Characters, Still no answer

Still no answer, perhaps, but ther'es still no question.

Per my earlier response What version of MySQL is the old version
you refer to, what version is the new version you refer to? With that
information someone here is more likely to be able to tell you
something useful without that you're not likely to get much of a
response.

Best Regards, Bruce

Aug 15, 2005, at 7:59 AM, James Sherwood wrote:

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. 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 NT 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
>
>
>

Hello.

You've already got a good answer:

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. 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 NT 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 (AT) rgisolutions (DOT) comwrote:

Sorry, dont know how I missed:

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.

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

Message
From: "Gleb Paharenko" <gleb.paharenko (AT) ensita (DOT) net>
To: <mysql (AT) lists (DOT) mysql.com>
Sent: Monday, August 15, 2005 1:41 PM
Subject: Re: French Characters, Still no answer

Hello.

You've already got a good answer:

--
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. 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 NT 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 (AT) rgisolutions (DOT) comwrote:
>
>

Hello.

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.

That means that data on the server is ok. Check the values of your
character_set_client, character_set_connection and character_set_results
variables from Tomcat's application. See:

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.

Perform an import so that all fields in your table have an utf8 character
set. And tune properly the connection variables.

"James Sherwood" <jsherwood (AT) rgisolutions (DOT) comwrote:
Sorry, dont know how I missed:

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.

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

I think I have found the problem:

Doing Select @@character_set_database , results, client and connection it
all returns
latin1

I tried set character_set_xxxxx = utf8; for them all but it did not work,
they stayed latin1 and need to be utf8

Any ideas how to change this?

Thanks,
James

Message
From: "Gleb Paharenko" <gleb.paharenko (AT) ensita (DOT) net>
To: <mysql (AT) lists (DOT) mysql.com>
Sent: Tuesday, August 16, 2005 11:16 AM
Subject: Re: French Characters, Still no answer

Hello.

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.

That means that data on the server is ok. Check the values of your
character_set_client, character_set_connection and character_set_results
variables from Tomcat's application. See:

--
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.

Perform an import so that all fields in your table have an utf8 character
set. And tune properly the connection variables.
--
"James Sherwood" <jsherwood (AT) rgisolutions (DOT) comwrote:
Sorry, dont know how I missed:

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.

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
>
>
>
>

Tue, 16 Aug 2005, James Sherwood wrote:

I think I have found the problem:

Doing Select @@character_set_database , results, client and connection it
all returns
latin1

I tried set character_set_xxxxx = utf8; for them all but it did not work,
they stayed latin1 and need to be utf8

Any ideas how to change this?

Which version of the Conenctor J are you using?, is it the latest?

We are using 3.0.9 and the latest is 3.1.10

But we connect to the old 4.0 database fine, would the connector matter?

James

Message
From: "Jason Pyeron" <jpyeron (AT) pdinc (DOT) us>
To: <mysql (AT) lists (DOT) mysql.com>
Sent: Tuesday, August 16, 2005 1:59 PM
Subject: Re: French Characters, Still no answer

--
Tue, 16 Aug 2005, James Sherwood wrote:

I think I have found the problem:

Doing Select @@character_set_database , results, client and connection
it
all returns
latin1

I tried set character_set_xxxxx = utf8; for them all but it did not
work,
they stayed latin1 and need to be utf8

Any ideas how to change this?
--
Which version of the Conenctor J are you using?, is it the latest?
--