Transfering Databases

2006-11-05 Thread Rob Cochrane
Hi All, I am a Web developer and have been using MySQL for a couple of years. I have just changed to a new development machine away from WinXP to Ubuntu Linux. My Dbase administration in the past has been via MySQL-Admin and SQLYog. I am now trying to bring all my databases into localhost and

Some Assistance Please

2005-08-30 Thread Rob Cochrane
Hi All, I have been using MySQL for some time in a basic and simple manner to retain prompt information and data for my multilingual websites. My new project is however a much larger matter. The site is a repository for advertisements advertising vehicles. This includes land sea and air

Re: How do you think about PostgreSQL and mysql?

2005-06-25 Thread Rob Cochrane
My choice was based on the fact that web requires a high number of reads and normally far fewer writes. The speed of MySQL in read is very fast compared to PostgreSQL. Where it comes to accounting, high transactions and such applications I will continue to use PostgreSQL till MySQLv5 becommes

Re: No Longer Receiving Emails

2005-05-27 Thread Rob Cochrane
Works Rob Tucker, Gabriel wrote: Hi I have not received anything from this list for a couple of days. I just tried to re-register, and that did not help. If anyone reads this, please reply to ME so I can determine if the problem is with my account or with the list. Thanks Gabe There

Re: Strange Issues

2005-03-02 Thread Rob Cochrane
Hi, I have included show from two tables both have the same problem in two different databases. Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.10-nt Type 'help;' or '\h' for help. Type '\c' to clear the

Strange Issues

2005-03-02 Thread Rob Cochrane
Hi, I have installed the query browser and it does change things but not correctly, inserting this: update `peterkrolltiles`.`navprompts` set `languagecode3`='afr', `navigation`='Navigasie', `home`='Tuis', `aboutus`='Oor Ons', `products`='Ons Produkte', `team`='Ons Span',

Re: Strange Issues

2005-03-02 Thread Rob Cochrane
Hi, Using the MySQL Query browser to enter the data the correct data is in the field and it remains correct. MySQLCC reads it incorrectly as does SQLyog. My applications which is .asp in one case and php in the other both read the data correctly. So at this stage the problem seems to have been

Re: Strange Issues

2005-03-02 Thread Rob Cochrane
of the file is correct, then the problem is in client. Rob Cochrane [EMAIL PROTECTED] wrote: Hi, I have installed the query browser and it does change things but not correctly, inserting this: update `peterkrolltiles`.`navprompts` set `languagecode3`='afr', `navigation`='Navigasie', `home`='Tuis

Re: Strange Issues

2005-03-01 Thread Rob Cochrane
or default to the language I detect from a lookup of his IP address. Many thanks Rob Gleb Paharenko wrote: Hello. Use set NAMES 'utf8'; to set the connection character sets to the corresponding values. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html Rob Cochrane [EMAIL PROTECTED

Re: Strange Issues

2005-02-28 Thread Rob Cochrane
Hi, After spending about a week researching the use of hex [string] values I am still as lost as I was before. What is the point of placing Unicode data into a column if I have to convert it when going both in and out? All the documentation I read on MySQL indicates it supports Unicode I cannot

Re: Strange Issues

2005-02-28 Thread Rob Cochrane
Hi Gleb, Ok here is the command line info which also answers the version question. Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.9-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show

[Fwd: Re: Strange Issues]

2005-02-28 Thread Rob Cochrane
Original Message Subject: Re: Strange Issues Date: Mon, 28 Feb 2005 20:47:37 +0200 From: Rob Cochrane [EMAIL PROTECTED] Organization: By Rob.com To: Rob Cochrane [EMAIL PROTECTED] References: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL

Strange Issues

2005-02-22 Thread Rob Cochrane
I am new to this list and to MySQL returning to Data Bases after many years away. I am developing multilingual web sites with all the info extracted from databases. In using MySQLCC/SQLyog to stack up some static base data into MyISAM tables the field type is text I discovered that some