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
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
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
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`='\
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
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
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
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
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
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
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]> <
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
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
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
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
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
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
17 matches
Mail list logo