Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
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 [EMAIL PROTECTED]
To: mysql@lists.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:
   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 [EMAIL PROTECTED] 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
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
Hello,

I dont think we want to go this route as it was working fine on the 4.0
database on the other server.

I also might add that the old server was linux, and the new one is Windows
2000 Server

Thanks,
James

- Original Message - 
From: Ace Dimitrievski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, August 15, 2005 6:38 PM
Subject: Re: French Characters, Still no answer


 Im not sure if my experience will be of any help but
 here it is:
 I used a database with utf8 as default charset (you
 can easily set this with mysql administrator) and the
 columns that I needed to store Macedonian cyrilic
 characters were varchar. Some letters were stored as
 ?. When I changed the column type to varbinary I was
 able to store/retreive all the letters properly.
 However if you change the type of the columns you
 cannot use the mysql adminisators backup sql queries
 to restore a database that contains utf8 characters
 (at least I failed). Using a PHP script will help. For
 those that use mySQL with some script language using
 base64 encoding/decoding funtions for non latin1
 letters is the safest way (however you cannot strictly
 predict the lenght of the encoded string based on the
 lenght of the plaintext).
 best regards
 ---
 Ace Dimitrievski,
 research assistant,
 Faculty of Electrical Engineering Skopje
 --- [EMAIL PROTECTED]
 [EMAIL PROTECTED] wrote:
  The older version is 4.xx.xx im not sure how to
 tell.
 
  New version is 4.1.12
 
  Thank you,
  James
 
 
  - Original Message - 
  From: Bruce Dembecki [EMAIL PROTECTED]
  To: James Sherwood [EMAIL PROTECTED]
  Cc: mysql@lists.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
  
   On 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.  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
   
  
  
   -- 
   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]
 


 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam protection around
 http://mail.yahoo.com

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



Re: French Characters, Still no answer

2005-08-16 Thread Gleb Paharenko
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:

  http://dev.mysql.com/doc/mysql/en/charset-connection.html





 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 [EMAIL PROTECTED] wrote:

 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

 

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]



Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
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_x = 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


- Original Message - 
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.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:
   http://dev.mysql.com/doc/mysql/en/charset-connection.html


  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 [EMAIL PROTECTED] wrote:
  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
 
 


 -- 
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.NET http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: French Characters, Still no answer

2005-08-16 Thread Jason Pyeron



On 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_x = 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?


--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron  PD Inc. http://www.pdinc.us -
- Partner  Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218   -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
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


- Original Message - 
From: Jason Pyeron [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 16, 2005 1:59 PM
Subject: Re: French Characters, Still no answer




 On 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_x = 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?


 -- 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 -   -
 - Jason Pyeron  PD Inc. http://www.pdinc.us -
 - Partner  Sr. Manager 7 West 24th Street #100 -
 - +1 (443) 921-0381 Baltimore, Maryland 21218   -
 -   -
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 This message is for the designated recipient only and may contain
 privileged, proprietary, or otherwise private information. If you
 have received it in error, purge the message from your system and
 notify the sender immediately.  Any other use of the email by you
 is prohibited.

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



Re: French Characters, Still no answer

2005-08-15 Thread Bruce Dembecki

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

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




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: French Characters, Still no answer

2005-08-15 Thread James Sherwood
The older version is 4.xx.xx im not sure how to tell.

New version is 4.1.12

Thank you,
James


- Original Message - 
From: Bruce Dembecki [EMAIL PROTECTED]
To: James Sherwood [EMAIL PROTECTED]
Cc: mysql@lists.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

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


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



Re: French Characters, Still no answer

2005-08-15 Thread Gleb Paharenko
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 [EMAIL PROTECTED] 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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]



Re: French Characters, Still no answer

2005-08-15 Thread Ace Dimitrievski
Im not sure if my experience will be of any help but
here it is:
I used a database with utf8 as default charset (you
can easily set this with mysql administrator) and the
columns that I needed to store Macedonian cyrilic
characters were varchar. Some letters were stored as
?. When I changed the column type to varbinary I was
able to store/retreive all the letters properly.
However if you change the type of the columns you
cannot use the mysql adminisators backup sql queries
to restore a database that contains utf8 characters
(at least I failed). Using a PHP script will help. For
those that use mySQL with some script language using
base64 encoding/decoding funtions for non latin1
letters is the safest way (however you cannot strictly
predict the lenght of the encoded string based on the
lenght of the plaintext).
best regards
---
Ace Dimitrievski,
research assistant,
Faculty of Electrical Engineering Skopje
--- [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
 The older version is 4.xx.xx im not sure how to
tell.
 
 New version is 4.1.12
 
 Thank you,
 James
 
 
 - Original Message - 
 From: Bruce Dembecki [EMAIL PROTECTED]
 To: James Sherwood [EMAIL PROTECTED]
 Cc: mysql@lists.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
 
  On 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.  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
  
 
 
  -- 
  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]
 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]