sorry i should have put the result of the show variables:
*************************** 5. row ***************************
Variable_name: character_set_client
Value: latin1
*************************** 6. row ***************************
Variable_name: character_set_connection
Value: latin1
*************************** 7. row ***************************
Variable_name: character_set_database
Value: latin1
*************************** 8. row ***************************
Variable_name: character_set_results
Value: latin1
*************************** 9. row ***************************
Variable_name: character_set_server
Value: latin1
*************************** 10. row ***************************
Variable_name: character_set_system
Value: utf8
*************************** 12. row ***************************
Variable_name: collation_connection
Value: latin1_swedish_ci
*************************** 13. row ***************************
Variable_name: collation_database
Value: latin1_swedish_ci
*************************** 14. row ***************************
Variable_name: collation_server
Value: latin1_swedish_ci
if the character_set_client is by default latin1, does that mean that the
java application is sending latin1?or is it changed at runtime?
kind of lost again.....
From: "mel list_php" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: character sets.....
Date: Tue, 08 Nov 2005 17:30:28 +0000
Hi guys,
I don't really understand the character set in mysql from the doc.
Tu summarize my problem:
users upload xml files (UTF-8).
part of the data is then inserted into MySQL (CHARSET=latin1)
at that point, when I browse via phpmyadmin (which is isolatin1) or export
to an html page no problem.(the application itself is in java)
when i want to allow users to download the xml file "reconstructed" in
UTF-8 some of the characters are "wrong".
I just inherited this application, so that's basically what I know about
it.
Is there any "conversion" done when data are inserted into the database?
Should I convert the db itself in utf8?
Or should I try to export it in isolatin1 when html and utf8 when xml?and
how?
I found
that:(http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html)
Example: Suppose that column1 is defined as CHAR(5) CHARACTER SET latin2.
If you do not say SET NAMES or SET CHARACTER SET, then for SELECT column1
FROM t, the server sends back all the values for column1 using the
character set that the client specified when it connected.
If I understand well, my java client is connecting sending utf8.I don't use
set names or character set, so when my java client asks "select......" the
result should be sent back in utf8 even if the db is latin1.
Is that correct?
and if it is, how does the html isolatin1 "interprets" the utf8?
any help/explanation very welcome...!
thanks a lot
melanie
_________________________________________________________________
The new MSN Search Toolbar now includes Desktop search!
http://toolbar.msn.co.uk/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Be the first to hear what's new at MSN - sign up to our free newsletters!
http://www.msn.co.uk/newsletters
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
