Recent content by Crundy

OK, that makes sense. If I put: header('Content-Type: text/html; charset=windows-1252'); at the top of the PHP page then it displays fine. I'm guessing that either Apache or PHP on the old server was configured to use the above charset but the new server is set to use UTF-8 by default. I'll have...

I've tried dumping and restoring one of the tables specifying the encoding on both and ommitting it on both and still get the same problem, so I suspect you are right. How do I check the system character sets and install any missing ones? C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

Hmm, using SHOW VARIABLES on both servers shows the same character sets and collations (latin1 and latin1_swedish_ci). So now I'm a little confused :\ C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

Hello, The original dump was in latin1, and I did specify this in the mysqldump command: /usr/bin/mysqldump -pmypassword --default-character-set=latin1 --port=3306 --host= -u myuser databasename And in the past this has been fine when restoring. There are loads of different characters, in...

Hi all, I moved a site across from one server running MySQL 4 to another running MySQL 5 and forgot to check the collation / encoding defaults on the servers. I'm therefore getting odd characters showing up in my web pages. As data has been entered into the new system since the restore I don't...

Hi all, I have an existing mysql database on a disk, and I want to mount the disk in the databases directory and start mysql to get the database back to where it was from a snapshot. I'm using this script: /etc/init.d/mysqld stop mkdir /var/lib/mysql/mydbname/ chown mysql...

That's excellent. Thank you. Have a star. C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

Hi all, Can someone give me a hand with this? I have an XML document which contains results of a questionnaire. The questions are listed at the top of the document and each user's response(s) are listed below. Users may not have answered all the questions, and if they have not answered a...

Ah, got it. short_open_tag is now off by default, and all my scripts use e.g. <? echo('test') ?> etc. Changed it to on and it works now. Live and learn. Thanks for all your help. C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

Yes, I was trying to run the php.ini file initially :-( I thought -c was to parse the php.ini for errors. Is there any way to check the php.ini file for errors? I did try copying my working installation from other machine, but it still didn't work. Are there problems with php on Vista...

Oh right. My bad. If I use a php.ini file then php doesn't parse my script. e.g. if I rename my php.ini to php.ini.offline and then run php test.php then it correctly parses the php file. If I leave php.ini named correctly then the above command just lists the contents of the file without...

I can't seem to get PHP to parse either of the php.ini files that comes with PHP 5.2.5: Running php -c . php.ini: php.ini-recommended: PHP Parse error: syntax error, unexpected T_LOGICAL_AND in C:\php\php.ini on line 126 php.ini-dist: Parse error: syntax error, unexpected ',' in...

Hello, I have a problem whereby I have a mailing script which pipes directly into sendmail, but the user is entering extremely long lines and sendmail is rejecting the email because of it. For the HTML portion of the email I can use encode_qp which works fine, but if I use encode_qp for the...

Nevermind, I managed to get the administrator to install dos2unix and it's working now. C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

It's definiely in the path, as I ran: -bash-3.00$ which perl /usr/bin/perl A simple hello world script works: #!/usr/bin/perl print "Content-type: text/html\n\n"; print "Hello world!!"; So it must be odd characters somewhere. Unfortunately I can't seem to find them or get rid og them. The...