Re: Strange Issues

2005-03-02 Thread Rob Cochrane
Hello, See my later post I will continue to test and supply all my results if I find it to be DB and not client Once again... many thanks Rob Gleb Paharenko wrote: Hello. Just tested on Windows 2k Professional (Russian) computer - the query works correctly. If you can make a reproducable test c

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 Gleb Paharenko
Hello. Just tested on Windows 2k Professional (Russian) computer - the query works correctly. If you can make a reproducable test case (the problem remains on other boxes) you may report a bug. Can you create a text file with a query and then execute it using a 'source' command (don't forget

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', `visualtour`='\

Re: Strange Issues

2005-03-02 Thread Gleb Paharenko
Hello. Does the problem remains with MySQL Query Browser and mysql command line client when you are using a 'source' command? Rob Cochrane <[EMAIL PROTECTED]> wrote: > Hi, > > I have included show from two tables both have the same problem in two > different databases. > > Enter

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 buf

Re: Strange Issues

2005-03-02 Thread Gleb Paharenko
Hello. Please, send us the output of the following statement: show create table 'your table'; > Hello Gleb, > > Below is an extract of the SQLyog history on startup > /*[02:26:25 PM][ 0 ms]*/ show variables like '%character%' > /*[02:26:25 PM][ 0 ms]*/ Set character_set_connecti

Re: Strange Issues

2005-03-02 Thread Gleb Paharenko
Hello. I also have a problems with MySQL Control Center, though it isn't supported now, and another client, MySQL-Front. But the latest MySQL Query Browser works perfectly with... Check your queries with MySQL Query Browser 1.1.5, you can download it from: http://dev.mysql.com/downloads/q

Re: Strange Issues

2005-03-01 Thread Rob Cochrane
Hello Gleb, Below is an extract of the SQLyog history on startup /*[02:26:25 PM][ 0 ms]*/ show variables like '%character%' /*[02:26:25 PM][ 0 ms]*/ Set character_set_connection=utf8 /*[02:26:25 PM][ 0 ms]*/ Set character_set_results=utf8 /*[02:26:25 PM][ 0 ms]*/ Set character_set_client=ut

Re: Strange Issues

2005-03-01 Thread Gleb Paharenko
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]> wrote: > Hi Gleb, > > Ok here is the command line info which also answers the

[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]> <

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

Re: Strange Issues (UTF-8)

2005-02-28 Thread brian ally
To me it should be a simple task. Insert <65k of text in Unicode or even simple ASCII format into a column of type 'text' by using a GUI client like SQLyog or MySQLCC and then extract it when needed by my web page without loosing everything I put in after a certain character or character sequen

Re: Strange Issues

2005-02-28 Thread Gleb Paharenko
Hello. At first, we should check that there is nothing wrong with the character_set_xxx variables. Please send us the output of the following statement: show variables like '%char%'; Does the problem remain if you are making the query using a mysql command line client? Do you use the

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-23 Thread Gleb Paharenko
Hello. > If important I am version running 4.1 on Win XP SP2 IIS. Use the latest release (4.1.10 now) and hexademical values. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html Rob Cochrane <[EMAIL PROTECTED]> wrote: > I am new to this list and to MySQL returning to

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 of