Shaun Adams schrieb:
> When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
> Does anyone know how I can resolve this?
>
>
>
> QUERY (windows server from the cmd prompt)
>
> mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
> --password=[PASSWORD] --
When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
Does anyone know how I can resolve this?
QUERY (windows server from the cmd prompt)
mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
--password=[PASSWORD] --host=[HOST] [TARGET DB]
ERROR MESS
Has anyone upgraded MySQL 4.0 to 5.0 on a Mac running Mac OS X
Panther, 10.3.9 Sever with Lasso 8.5.4? I'm debating whether to just
upgrade to MySQL to 5.0 or jump to Apples Leopard Server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello all,
I am trying to add a field to a very large table. The problem is that mysql
locks up when trying to do so. I even tried deleting the foreign keys on
the table and it wont even let me do that, again locking up.
It works for around 5 minutes or so then just either locks or the data
[EMAIL PROTECTED] wrote:
Hello mysql,
I have a PHP script that I have written and it runs beautifully on
current MySQL and PHP sites BUT, it barfs on MySQL 4.0 because I am
using the DATE() to extract the Date from a timestamp. Does anyone
remember how to do an equivalent function in 4.0? I
Hello mysql,
I have a PHP script that I have written and it runs beautifully on
current MySQL and PHP sites BUT, it barfs on MySQL 4.0 because I am
using the DATE() to extract the Date from a timestamp. Does anyone
remember how to do an equivalent function in 4.0? I have searched
through hundreds
Hello all,
I'm running MySQL 4.0.24 on Debian Linux and have a problem with a very
large blob insert query - it always fails with "#2020: Got packet bigger
than 'max_allowed_packet'". I searched the docs and found some
references that this value can not be greater than 1 GB with MySQL 4.x -
indeed
Yes, I did try. The issue was the security level setting on the new DB
server, and not the password stuff. I've upgraded apache, mysql, and php
in the last few weeks, and 3-4 issues became painfully apparent when going
from php4 to php5, so I guess I was operating under similar assumptions
and
Have youtried this yet? While 4.0 client can't connect to a v.5
server unless the passwords have explicitly beewen stored as
old_password, I have never run into an issue connecting a 5.x client
to a 4.0 server.
- michael
On 6/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Is it possible t
Is it possible to connect to a 4.0.18 DB from the client of a 5.0.27
system? I know there is an old_passwords function. Can this be used
somehow from a DOS command prompt?
David
Regarding the format of TIMESTAMP columns, one of the user comments on
http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html
offers the solution below:
Posted by Kjell Arne Rekaa on April 14 2005 11:11pm
If you want the same view of a timestamp field in 4.1.x as it was in
in earlier mysql ver
Hi! I would like to upgrade the database of my organisation from
mysql4.0.22 from 4.1. We use Debian.
I've read info in the manual, but i don't have things clear.
We process data of DB with scripts, and I'm annoyed because the change
of format of timestamp, is there any command in 4.1 to obtain
ry it works
fine on mysql-5.0 but it give error with mysql-4.0.
Query**
SELECT c.MASTER_CO_ID as Expr1 FROM company
LEFT OUTER JOIN (select MASTER_CO_ID,SLAVE_CO_ID from favorites where
MASTER_CO_ID = '1' GROUP BY MASTER_CO_ID,SLAVE_CO_ID) c ON company.
with mysql-4.0.
Query**
SELECT c.MASTER_CO_ID as Expr1 FROM company
LEFT OUTER JOIN (select MASTER_CO_ID,SLAVE_CO_ID from favorites where
MASTER_CO_ID = '1' GROUP BY MASTER_CO_ID,SLAVE_CO_ID) c ON company.CO_ID =
c.SLAVE_CO_ID
GROUP BY
Hello everybody,
I'm using Query Browser 1.1.17 on Windows with a MySQL 4.0 database
server on Linux and was just editing a piece of text for a web CMS in
the database. But what do I get to see there? The content was stored as
UTF-8, although the website uses ISO-8859-1 encoding, the dat
erformance
characteristics compared to MySQL 4.0.
For this test, it imports one of our customer databases, records the
import time, drops the database, and restarts. I've run this test
against the 4.0, 4.1 and 5.0 binaries. I've found a *dramatic*
performance drop on the 4.1 and 5.0 l
You should use:
SELECT username FROM workflow.user WHERE username LIKE BINARY 'NicO' LIMIT
1;
reference:
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
On 12/12/05, Nico Sabbi <[EMAIL PROTECTED] > wrote:
>
> Hi,
> my mysql always executes case insensitive queries:
>
>
>
Nico Sabbi wrote:
Hi,
my mysql always executes case insensitive queries:
SELECT username FROM workflow.user WHERE username = 'NicO' LIMIT 1;
+--+
| username |
+--+
| nico |
+--+
1 row in set (0.01 sec)
that field is of varchar(255) type.
I don't understand the r
Hi,
my mysql always executes case insensitive queries:
SELECT username FROM workflow.user WHERE username = 'NicO' LIMIT 1;
+--+
| username |
+--+
| nico |
+--+
1 row in set (0.01 sec)
that field is of varchar(255) type.
I don't understand the reason for this beha
Mohsen wrote:
> But himself solved his problem.
> with : mysql_query("SET NAMES utf8");
> Even 4.0.x
Wrong.
I decided to prepare two different versions for my software:
- A MySQL 4.0-friendly version using Romanizing method (Hats off to you,
Ehsan)
- A M
lve this by upgrading.
> Many of the Hosting Companies, which I use their services [even
> the HostRocket.com] still use MySQL 4.0 !!!
Googling for gives a number of companies offering
MySQL 4.1 and PHP 5. Obviously I cannot comment on their competence.
>
> 1) Would you recommend a
you upgrade.
Dear Alec,
Thank you for your prompt reply.
You're right. That's my problem. I admit it.
But I'm really unable to solve this by upgrading.
Many of the Hosting Companies, which I use their services [even the
HostRocket.com] still use MySQL 4.0 !!!
1) Woul
Assuming this, I tried to save the records as Unicode Character
> References (&#;), but the search failed again :-(
>
> Any suggestion?
> I appreciate any solution to solve this problem.
>
> Thanks in Advance,
> Behzad
>
>
> [1] MySQL Manual -> 6.8.3 Full-te
o solve this problem.
Thanks in Advance,
Behzad
[1] MySQL Manual -> 6.8.3 Full-text Search TODO
[2] MySQL Manual -> 6.8 MySQL Full-text Search
P.S.
I use MySQL 4.0
1) Table Strucutre
CREATE TABLE `articles` (
`article_id` int(10) unsigned NOT NULL auto_i
I have solved this problem, I was missing a slash in the path to the data
directory
Thanks,
James
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October 26, 2005 4:41 AM
Subject: Re: Mysql 4.0 cpu usage
> Hello.
>
> A
Hello.
Are you able to connect to the server and found the states of its
threads with SHOW PROCESSLIST statement?
> Mysql 4.1 and 5 will NOT seem to play nice with french characters so I
have tried to
> revert back to 4.0.
>
> I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850
On Tue, 2005-10-25 at 15:39 -0300, James Sherwood wrote:
> Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have
> tried to revert back to 4.0.
>
> I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run
> the service it uses a constant 25%cpu and seems l
Hello,
Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have
tried to revert back to 4.0.
I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run the
service it uses a constant 25%cpu and seems locked up. I cannot even stop the
service I have to end th
Hi all,
Willing to test an upgrading path from 4.0 to 4.1 database of MySQL.
Could someone provide a link or some slice of unload from a 4.0 with
encodings different from "latin1" ?
Thanks in advance,
Francesco R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Yah, I tested in SQL*Plus - one window could see inserts, updates and
deletes that had been committed in another window (in which a commit or
rollback had not been issued). I ran the test again - delete data from a
table in one window and commit the change, and a select in the other
window disp
If you are NOT in autocommit mode, your connection (or the server, it
doesn't matter which) starts a transaction *when you issue your first
command*. Every command you issue on that connection is in that initial
transaction until you EXPLICITLY commit or rollback (or do something else
that comm
I believe you - I'm just a but surprised. I guess I had a singular view
of how a session should work based on Oracle. I would have expected that
until you execute SQL that requires a commit or a rollback, you wouldn't
be in a transaction. Unfortunately, if you have connections that are
read and
David Griffiths wrote:
"No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
h
"No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
http://dev.mysql.com/doc
On Wed, Aug 31, 2005 at 11:18:40PM -0400, Michael Stassen wrote:
> No, with the default transaction isolation level, REPEATABLE READ, that's
> how it is supposed to work. You've started a transaction in Window B, so
> Window B is immune to changes made in Window A until you finish the
> transac
David Griffiths wrote:
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned on still shows up in the
ccordingly... The benefit here is your downtime is minimal but the
> problem is at the end of the day you are still left with your shared
> innodb table space, and even though it may be mostly empty, you can't
> clean it up and make it smaller.
>
> Best Regards, Bruce
>
> O
hi,
should I use mysqldump from the Mysql 4.0 or 4.1?
Regards,
Rafal
p.s.
Thx for all other tips!
At 21:44 23.08.2005, Bruce Dembecki wrote:
Once you decide to use mysqldump, be aware that the quickest way to
export/import large files is to use the --tab feature on export and
mysqlimport to
al Kedziorski wrote:
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an
bug, which was fixed in MySQL 4.1. We are using tracactions and
InnoDB is don't use query cache. Now we have to migrate our DB to
MySQL 4.1 for use this feature. In our actual installation we s
Hello.
Use mysqldump, but be aware of incompatibles between 4.0 and 4.1:
http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Rafal Kedziorski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> we have an J2EE application which ist using MySQL 4.0. There is an
> bug, which
J2EE application which ist using MySQL 4.0. There is an
bug, which was fixed in MySQL 4.1. We are using tracactions and
InnoDB is don't use query cache. Now we have to migrate our DB to
MySQL 4.1 for use this feature. In our actual installation we store
our data in one inndodb file. After mi
2EE application which ist using MySQL 4.0. There is an
> bug, which was fixed in MySQL 4.1. We are using tracactions and
> InnoDB is don't use query cache. Now we have to migrate our DB to
> MySQL 4.1 for use this feature. In our actual installation we store
> our data in one inndod
Would I be correct in assuming you need to minimize down time on a
productions system? Or are you just asking how to upgrade?
On Tue, 23 Aug 2005, Rafal Kedziorski wrote:
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an bug, which
was fixed in MySQL 4.1. We are using
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an
bug, which was fixed in MySQL 4.1. We are using tracactions and
InnoDB is don't use query cache. Now we have to migrate our DB to
MySQL 4.1 for use this feature. In our actual installation we store
our data in one in
Marco wrote:
So how can I do that?
There's nothing special you need to do with MySQL itself. Somehow your
program obtains UTF-8 data. Insert said data into database. That's it.
Perhaps you should read up on UTF-8, to see why this is so.
Again, don't expect the database server to be able
So how can I do that? I've already tried SET CHARACTER SET and it
didn't work since someone said its not available in MySQL 4.0.
You can store UTF-8 in any database in the world. UTF-8 is
compatible with any application capable of dealing with
null-terminated strings of 8-bit
Warren Young wrote:
That's why it's possible in the Unix/C world,
Typo: should be "That's why it's _popular_..."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Marco wrote:
So is there any solution on how I can properly use foreign characters
and store them in a MySQL 4.0 database?
You can store UTF-8 in any database in the world. UTF-8 is compatible
with any application capable of dealing with null-terminated strings of
8-bit characters
SET CHARACTER SET ut8; won't work.
My server admin said UTF8 has not been mentioned in 4.0 thus I am
unable to use it.
So is there any solution on how I can properly use foreign characters
and store them in a MySQL 4.0 database?
--
MySQL General Mailing List
For list archives:
Hello.
It is not clear from you message what's the problem. From your
calculations I can see that the length of int field in a flat
file row (BTW please send a piece of your file) is different
in mysqldump programs with different versions? How is the length
of integer fields related to cha
the version is 4.1.12.
show variables like this,
| character_set_client|
latin1
| character_set_connection|
latin1
| character_set_database |
latin1
| character_se
Hello.
> Any possible problems with this approach?
It is good, if it solved your problems.
>> So it works for me.
>
> I've ended doing this in a different way. I've created a patch which forces=
> a=20
> file to be read - /etc/mysql/mysql-client.conf (which is the same as .my.cn
On Monday 11 of July 2005 16:24, Gleb Paharenko wrote:
> Hello.
>
> I've tested your solution. It doesn't work for users which have SUPER
> privilege. This mentioned at:
> http://dev.mysql.com/doc/mysql/en/server-system-variables.html
>
> However, it works with with ordinary users which don't hav
Hello.
I've tested your solution. It doesn't work for users which have SUPER
privilege. This mentioned at:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
However, it works with with ordinary users which don't have SUPER
privilege. Here are pieces of my my.cnf (the init_co
On Thursday 07 of July 2005 00:16, Gleb Paharenko wrote:
> Hello.
>
>
> For a pity, I could give explanations only for your query about
> selecting @@global.xxx variables. I think server returns correct
> results, because you're selecting global variables, while
> character_set_client, character_se
r mysql program. Be aware of that
mysqldump could put SET NAMES at the beginning of the dump file. Use
set-names=latin2 for it. See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Arkadiusz Miskiewicz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have mysql 4.0 db with
Hi,
I have mysql 4.0 db with configuration:
set-variable = default-character-set=latin2
set-variable = character-set=latin2
now I'm trying to migrate to mysql 4.1.12 My current config is:
character-set-server=latin2
collation-server=latin2_general_ci
The problem is connection/reply/c
Andrew Hargreaves wrote:
> In MySQL 4.0, is it possible to find all records that don't exist in one
>query. I managed to do it in Access by referencing a query that I had
>previously created, but I was wondering if it was possible to do this in one
>step.
>
>
Not in
In MySQL 4.0, is it possible to find all records that don't exist in one
query. I managed to do it in Access by referencing a query that I had
previously created, but I was wondering if it was possible to do this in one
step.
SELECT C.CustomerID, ([JobStatus]="0" And [JobTypeID
Hi,
I upgraded MySQL 4.0 to 4.1 and imported all data using phpmyadmin.
All accented letters (italian, french, spanish) have been replaced by asian
characters...
and now the default collation for tables and varchar fields is:
"latin1_swedish_ci"
I'm only using european language
Hello.
Please send us an output of the following statement:
SHOW VARIABLES LIKE '%char%';
See:
http://dev.mysql.com/doc/mysql/en/charset-conversion.html
Bruce Dembecki <[EMAIL PROTECTED]> wrote:
> Hi! We have a problem converting our 4.0 text columns from a Hong Kong
> database
Hi! We have a problem converting our 4.0 text columns from a Hong Kong
database to 4.1. In order to get the conversions to work generally speaking
we build our databases with default character set utf8 - it means the German
products still work, and the English ones, and the Chinese ones, and the...
A bit of a warning, if the fields are DATETIME rather than DATE, add the
appropriate hours:minutes:seconds to the test
WHERE datetimefield >'1999-02-01 23:59:59'. When comparing DATETIME fields
with date strings '00:00:00' is assumed and that can cause problems if one
forgets that.
> Have you consi
Sorry. This should have gone back to the list.
-- Mensaje reenviado --
Subject: Re: MySQL 4.0 and concat
Date: Lun 11 Oct 2004 11:37
From: Alfredo Cole <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
El Lun 11 Oct 2004 08:35, escribió:
> Have you considered NOT comparing
Have you considered NOT comparing dates as strings but rather as date
values? That will avoid the use of CONCAT() completely.
SELECT *
FROM sampletable
WHERE datefield >= '1999-01-12' and datefield <'1999-02-01'
This example query will get all of the records from sampletable that were
entere
Hi:
I have a problem in that all statements that include concat execute very
slowly. For instance, if I have three fields in string format that represent
a year, month and day, and want to issue a select like:
select * from cxcmanpag where contact
(year,month,day)<=stringYear+stringMonth+stri
Yes. Best of luck with your conversion!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
<[EMAIL PROTECTED]> wrote on 09/30/2004 05:25:22 PM:
>
> Hi,
>
> Thank you very much for your reply. So for the cursors result
> set C API's will be suitable ..right?.
>
> thanks,
Hi,
Thank you very much for your reply. So for the cursors result set C API's will be
suitable ..right?.
thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of
onot
> know). And used some stored procedures at module level and some
> triggers on some table before/after updating.
> The above existed system's whole database layer including table
> layer/views layer and DBView layer to be migrated to mysql 4.0 with
> out innodb. Need
> Could you please let me know the alternatives for stored procedures and
Triggers in mysql 4.0.
The only alternative is application code.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upsc
d system's whole database layer including table layer/views layer and
DBView layer to be migrated to mysql 4.0 with out innodb. Need to change the API's
also. So, the views/stored procedurs (some of them used cursors)/ triggers need to be
converted to mysql 4.0 from oracle 7.3. Th
hank you for your response. Strictly we have to use mysql 4.
> 0 only. Actually the source data base is oracle 7.3, we need to
> migrate that database to mysql 4.0 . In oracle 7.3 views/cursors are
> used. That is why i need an alternative for views/cursors in mysql
> 4.0. We use C/C+
Hi,
Thank you for your response. Strictly we have to use mysql 4.0 only. Actually
the source data base is oracle 7.3, we need to migrate that database to mysql 4.0 . In
oracle 7.3 views/cursors are used. That is why i need an alternative for views/cursors
in mysql 4.0. We use C/C++ for
t;[EMAIL PROTECTED]> wrote on 09/30/2004 03:01:51 PM:
>
> Hi,
>How to implement views/cursors in mysql 4.0?. Normally in
> mysql how the selected data is maintained in the recordsets?. Is
> there any other alternatives to implement views/cursors in mysql 4.
> 0?. Please advi
Hi,
How to implement views/cursors in mysql 4.0?. Normally in mysql how the
selected data is maintained in the recordsets?. Is there any other alternatives to
implement views/cursors in mysql 4.0?. Please advise me for the better solution.
Thanks,
Narasimha
Confidentiality Notice
Hi,
I've used MySQL 3.23 on Redhat 9 for a long time. Recently, I'm thinking of
using MySQL 4 because some applications need it. I download a rpm from
mysql.com and have it rpm. It can't start and comes up with problem as
-==
terribly wrong...
Bogus stack limit or frame pointer, fp=0xbfffd2b8, st
e.
>
> Thanks,
> Narasimha
> 91 98456 82459
>
> -Original Message-
> From: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE
> PROVIDER)
> Sent: Tue 8/17/2004 3:08 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc:
>
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc:
Subject: RE: Migration tools/plan from oracle 7.3 to Mysql 4.0
Hi,
Thank you for your response. Could any one give more clarification on
the alternatives for Views, Stored procedures
cess denied for user: '@localhost' to database 'mysql'
I can only bypass this error if I use -u root ?
Thanks,
Francois A
-Original Message-
From: Julian [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 12:04 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysql 4.0 windows
> May someone please send me the link to download mysql Binary distribution
> for the first time on windows XP, I have looked into mysql/downloads and
> they only have X86.
Windows XP, and every other windows platform, runs on X86 architecture.
That is the download you want.
Jeff
--
My
May someone please send me the link to download mysql Binary distribution
for the first time on windows XP, I have looked into mysql/downloads and
they only have X86.
Thanks,
Francois A
Martijn Tonies wrote:
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With "application code", I meant
that you:
- have to change your queries so that they include the full VIEW sql,
because MySQL doesn't have an alternative
- have to recreate your stored procedures in application code and
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Hi Narasimha,
Please reply to the MySQL list instead of me personally only.
> How we can write the equivalent code for triggers of
>oracle in Mysql?. Shall we do it by using User Defined
>Functions?. Can we use database queries inside the user
s, triggers, stored procedures and
contraints of Oracle to Mysql 4.0 classic version (This does not vave innodb engine).
Thanks,
Narasimha
919845682459
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tue 8/17/2004 3:45 PM
To: Lakshmi Na
> Thank you for your response. Could any one give more
clarification on the alternatives for Views, Stored procedures, triggers and
contraints of oracle in Mysql 4.0 classic, as MySql 4.0 classic wonot
support the InnoDB storage engine.
>
Well, what other alternative do you ha
Hi,
Thank you for your response. Could any one give more clarification on the
alternatives for Views, Stored procedures, triggers and contraints of oracle in Mysql
4.0 classic, as MySql 4.0 classic wonot support the InnoDB storage engine.
Thanks,
Narasimha
-Original
First: please don't hijack threads... And don't quote them completely
if you do.
> I am new to MySql. Could you please let me know the different
migration tools avialable for the migration of oracle 7.3 database to mysql
4.0 classic version.
You could try the Schema Mig
Hi,
I am new to MySql. Could you please let me know the different migration tools
avialable for the migration of oracle 7.3 database to mysql 4.0 classic version. Out
of those which one is the best in performance and cost wise. As per my knowledge
views, stored procedures and triggers
Does that means that we need to change the column type from varchar to some other
type? Which type to use?
thank you.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 6:24 PM
To: [EMAIL PROTECTED]
Subject: Re: set up UTF8 for MySQL 4.0.x
ng Zhang
(BCc: [EMAIL PROTECTED]
(BSubject: Re: set up UTF8 for MySQL 4.0.x
(B
(B
(BHello,
(B
(BI have made apresentation at MySQLs UC2004 about using Japanese character
(Bsets with MySQL. You may find this a good starting point. Links are below:
(B
(Bhttp://dev.mysql.com/doc/mysql/en/Char
"Guofeng Zhang" <[EMAIL PROTECTED]> wrote:
> Our web site will store the text in a number of languages in the mysql =
> DB, so that we think that MySQL should be configured to store chars in =
> UTF8.
>
> For my requirement, how to configure the MySQL. to store Unicode =
> characters?
No need.
Our web site will store the text in a number of languages in the mysql DB, so that we
think that MySQL should be configured to store chars in UTF8.
For my requirement, how to configure the MySQL. to store Unicode characters?
Thank you very much.
--
MySQL General Mailing List
For list archiv
It's possibly due to your ssh connection but I couldn't answer you about
this because I only use mysql with phpmyadmin.
Regards
Yves wrote:
Thanks,
As it turns out, I was trying show variables like --
And had a syntax mistake
Does SHOW VARIABLES only show a certain number of
lines? When I ran
Thanks,
As it turns out, I was trying show variables like --
And had a syntax mistake
Does SHOW VARIABLES only show a certain number of
lines? When I ran this command, character_set was not
listed... the list seemed cut off just before it.
Unless it is an issue with SSH only showing x amoun
You can see it by executing the "SHOW VARIABLES" query on your server.
You will find the used charset in the 'character_set' variable.
You can also use the query "SHOW VARIABLES LIKE 'character_set'" which
will directly match what you want.
Yves wrote:
Hello,
How can I see what char set is bein
Hello,
How can I see what char set is being used as the
default char set on the server or database?
Also, is there a way to change the default setting?
Thanks,
Yves
__
Post your free ad now! http://personals.yahoo.ca
--
MyS
Michael Stassen" <[EMAIL PROTECTED]>
To: "fgmmoribe" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, July 27, 2004 7:11 AM
Subject: Re: select in Mysql 4.0
fgmmoribe wrote:
I have a table like this
+-+---+---
gt;
>
> Is there anyway to make select command like this in Mysql 4.0:
> select * from #temp where cod in (select max(cod) from #temp
> group by idtable) order by data desc
>
> could someone help me?
>
> thanks
>
> Fernando
>
>
> --
> MySQL General Mai
IL PROTECTED]>
Sent: Tuesday, July 27, 2004 7:11 AM
Subject: Re: select in Mysql 4.0
>
> fgmmoribe wrote:
> > I have a table like this
> >
> >
+-+---+--+-+-+--
1 - 100 of 339 matches
Mail list logo