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]
