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
