Make sure you're using the latest version of the driver (2.0.14 right now)
from http://mmmysql.sourceforge.net/
Also, make sure you add "useUnicode=true" to your URL if you're not going to
be using straight ASCII.
-Mark
----- Original Message -----
From: "Daniel Flöijer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 2:16 PM
Subject: charset
Hello,
I'm having really strange problems with characters when retrieved to Java
from MySQL. On some columns (or if it is in some tables) it works, in others
it do not. I have checked what charset Java thinks it should be, and that is
cp1252 in both cases. I've checked the list of MySQL supported charsets, and
cp1252 is not even among them, but that is not the problem, because it works
in some cases. A friend said cp1252 is the windows standard, so I'm
wondering if what you call cp1251 (and the deprecated win1251) is really
cp1252? Anyway, I have tried reading the data as some of the other charsets
provided by MySQL, most importantly beeing latin1, but none worked. I am
also wondering if latin1 really is the default used by MySQL, it seem more
likeley that it is cp1251/cp1252. This is still not the problem, just a bit
missguiding if it is really the case. Also I found no way of determine what
charset MySQL really is using, only ways of chaning it, but that's not what
I want to do. I've also check the SQL datatypes (VARCHAR), but they are the
same, even the same length (60). Since everything seem ok in java it seem
this problem is somewhere in MySQL.
Anyway, I'm using MySQL 3.23.51, Java 1.4.0 and mmJDBC 2.0.14 on a windows98
machine. And if it matters it's swedish characters I'm trying to get (åäö).
Also, it seem to be quite hard to find the right list to post to from the
website, this is the second time I post, and I never found the right one on
my first atempt. A bit clearer on where to post on the website would
probably be good.
Regards,
Daniel Flöijer
-----------------------------------
[EMAIL PROTECTED]
+46(0)70 - 669 2265
www.ZkilfinG.net
-----------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
