MySQL, D7 and UniCode

I am in a very strange situation. First, I have been very lucky. I work at a university, and have had a somewhat vague feeling that the machine I have been using for the past three years (a Dell Latitude X200 with Win2000 on) has had problems, probably with the hard disc. So, I managed to persuade the persons in power that I probably would need a new machine pretty soon. So I ordered a new one from Dell (a Latitude D410, large disc, lot of memory, and fast processor). Nice. Two days before the new one was supposed to arrive, I got the message "No operating systm found" from the old one. I had backup (a MaxStor thingie with appropiate software, worth its weight in gold), so no problems there. So far so good.

The new machine had Windows XP on it. After a while, as I was installing all the software on it, including D7, I started to see that the operating system was in some ways oriented towards UniCode. That created problems. I use MySQL for some applications, and for accessing a MySQL data base from Delphi, I have been using MyCompontents from SciBits. To reinstall the MyComponents part I had to paste their password from the web page to a non-UniCode application (Help&Manual) and then to the install procedure for the components thing. That worked OK. So the install part for SciBit is dependent on old character sets.

Then it turned out that a "#" in the password for the access to MySQL was causing problems. If the root password for MySQL was changed into something with only english type letters, I managed to get past the logon at least.

So the question is: in tyhe combination of Windows XP, Delphi 7 and MySQL, what are the issues? Should I use something else than SciBit MyComponents?

By the way, does Delphi 2005 support MySQL?

Tom
.

Relevant Pages

  • DBI / DBD / MySQL installation problem
    ... I used to run Red Hat 9, and had a perfect relationship with Perl, DBI, ... able to connect to MySQL from Perl via DBI. ... Running install for module Mysql ...
    (perl.dbi.users)
  • Installing Puresecure on Solaris 8
    ... Getting puresecure installed on Solaris was very difficult. ... I had to manually install a number of things. ... CONFIGURING MYSQL: ... INSTALLING PERL MODULES ...
    (comp.security.misc)
  • Re: Problem installing Mysql from Zeniz.com on 5.0.7
    ... The FSU-threads needs the system to have all the latest patches. ... FSU-threads and MySQL are very tempramental to system changes and the way ... Please specify the operating system you want to install Pthreads on: ... SCO UNIX ...
    (comp.unix.sco.misc)
  • Re: MySQL gem problem on OS X [SOLVED]
    ... My mysql gem 2.7 is installed in the following directory: ... I have a symlink to the full name of the install to simplify the path name. ... using UNIX command cd) your way to each of those directories in separate terminal windows. ... but start with sudo. ...
    (comp.lang.ruby)
  • Re: Enabling MySQL for PHP on CentOS 5
    ... I cannot get PHP to use mysql correctly. ... find are instructions to install each portion from scratch. ... If you have the mysql-dev and apache-dev packages installed, ...
    (comp.os.linux.misc)