IMO, it's a bad idea to still use Latin-1 these days.  The best way
is to find out why you can't insert those characters.  Well, I don't
know why you can't do so.  Maybe there's because the MySQL provided by
EasyPHP is quite old.

    By the way, since you use EasyPhp, that implies you're using
Windows.  You could very well forget about EasyPHP and download an
official MySQL.  You don't use either Apache or Php from EasyPHP,
right?  If yes, there's no reason to still keep it.  Go here and
download the community edition:
http://dev.mysql.com/downloads/

    While you're there, you could also download the Connector/J.

    As to configuring MySQL, it's quite intuitive and there's not much
to say.  I'm making web pages explaining how to make MySQL+Tomcat to
work but it's still under construction, so I can't show you.  But if you
like, here's a little detail (b.d. means you could just choose the
parameters by default):

    After a "complete" installation of MySQL, there's the Setup Wizard. 
"Skip sign-up" if you want next>
"Detailed Configuration" (b.d.) next>
Developer Machine (b.d.) next>
Multifunctional Database (b.d.) next>
Tablespace (b.d.) next>
Decision Support (b.d.) next>
TCP/IP & Strict Mode (b.d.) next>
Here, you'd better choose "Best Support for Multilingualism" option next>
(b.d.) and better choose "Include Bin Directory in Path" next>
specify your password and "Enable root access from remote machine" if
you want.

    That's it!

    I would suggest you to download the Administrator and Query Browser
from the same download page which you would find very useful and
intuitive.  But their use is off-topic to this mailing-list and to avoid
flame, send me private mail if you need more help on them.

    Seak

Seak, Teng-Fong wrote:

> ary martini wrote:
>
>>Hi Seak,
>>thank you for your response.
>>1) mysql has charset Latin
>>I would like to use ISO-8859-1 as encoding, as I can then insert special 
>>characters like è and à. For some reason it does not work for UTF-8 in my case
>> 
>>Do you know How I can change the charset on mysql?
>> 
>>I cannot locate any config file etc.
>> 
>>I use Easyphp containing mysql 4.0
>> 
>>Thank you very much for your input
>>Ary
>>
>>
>>    
>>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to