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
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]
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:http
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
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
[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 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,
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
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 to
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
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
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
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 c.MASTER_CO_ID
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.CO_ID =
c.SLAVE_CO_ID
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 data
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 lines against the 4.0
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
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
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:
SELECT
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 MySQL 4.1-compatible
the HostRocket.com] still use MySQL 4.0 !!!
Googling for hosting mysql 4.1 gives a number of companies offering
MySQL 4.1 and PHP 5. Obviously I cannot comment on their competence.
1) Would you recommend any hosting company with PHP 5 and MySQL 4.1
support?
2) What about if my client only use
] 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_increment,
`article_title` NATIONAL varchar(255) NOT NULL default
any solution to 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
***
I think this is your problem: MySQL does
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) Would you recommand any hosting
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
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: mysql@lists.mysql.com
Sent: Wednesday, October 26, 2005 4:41 AM
Subject: Re: Mysql 4.0 cpu usage
Hello.
Are you able
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
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
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
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
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
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
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
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
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
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
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
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 inndodb
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
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 migration we wan't use file
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 migration we
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 was fixed in MySQL 4.1
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 inndodb file. After
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
it may be mostly empty, you can't
clean it up and make it smaller.
Best Regards, Bruce
On Aug 23, 2005, at 6:19 AM, 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 tracactions
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 characters
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
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]
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: http
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
the version is 4.1.12.
show variables like this,
| character_set_client|
latin1
| character_set_connection|
latin1
| character_set_database |
latin1
|
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 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,
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
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 have
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/client
. 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 configuration:
set-variable =3D
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]=2) AS KountNA
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 one step, no. If you're still
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 languages in the DB, so
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 to
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
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
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
entered
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 dates
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
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,
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
] 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 advise me for the better solution
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
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 Programming. could you please
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. That is the requrement
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.upscene.com
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 to change the API's also. So, the views/stored
procedurs (some of them used
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
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,
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
-Original Message-
From: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE
PROVIDER)
Sent: Tue 8/17/2004 3:08 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc:
Subject: RE: Migration tools/plan from oracle 7.3
to Mysql 4.0
Hi
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
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
--
: '@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 XP Downloads
That's it. You had it. x86
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 Migrator tool
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
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 have
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 NarasimhaRao (WT01 - TELECOM SERVICE PROVIDER
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
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
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
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
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. Just
(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/Charset.html
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
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
--
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 being
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
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
: Re: select in Mysql 4.0
fgmmoribe wrote:
I have a table like this
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra
| | | 0 | |
| title | varchar(150) | YES | | NULL |
|
| description | varchar(150) | YES | | NULL | |
| date | datetime | YES | | NULL | |
+---+-+--+-+-++
Is there anyway to make select command like this in Mysql 4.0:
select * from
[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
+-+---+--+-+-++
| Field | Type
1 - 100 of 322 matches
Mail list logo
