File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes save my life, how to change mysql encoding Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "save my life, how to change mysql encoding" Watch "save my life, how to change mysql encoding" New topic

save my life, how to change mysql encoding

Hussein Baghdadi
clojure forum advocate

Joined: Nov 08, 2003
Posts: 3479

Hi ranchers.
As you know, Mysql 4.0.4 use ISO-8859-1 charset by default.
I want to change this attribute, and I have read Mysql docs and find the following:
To change the default set, use the --with-charset option
shell> ./configure --with-charset=CHARSET
ok, but I am using WinXP, and I have installed Mysql in the dir "F:\MySQL"
so please tell how to deal with this command using WinXP.
(I mean, please give the right command for windows).
Barry Gaunt
Ranch Hand

Joined: Aug 03, 2002
Posts: 7729
The ./configure stuff is usually done when you build something from source code on a unix/linux system. So it could be that you will have to do that somehow on your windows system.
On the other hand I just found this. It looks as if you can change the default character set when you start the server.
[ February 18, 2004: Message edited by: Barry Gaunt ]

Ask a Meaningful Question and HowToAskQuestionsOnJavaRanch
Getting someone to think and try something out is much more useful than just telling them the answer.
I agree. Here's the link:
subject: save my life, how to change mysql encoding
jQuery in Action, 3rd edition