Okie, i will also try this, as we also load data from a flat file.
regards
anandkl
On 8/31/07, Harald Vajkonny <[EMAIL PROTECTED]> wrote:
>
> Hi Ananda,
>
> Ananda Kumar schrieb:
> >
> > So you set the collation_database=utf8_bin, what was your
> > character_set_database values.
> character_set_
Hi Ananda,
Ananda Kumar schrieb:
>
> So you set the collation_database=utf8_bin, what was your
> character_set_database values.
character_set_database is "utf8". The collation utf8_bin slows down
queries, but is necessary in dealing with multilingual information.
utf8_general_ci is faster, but can
Hi Harald,
So you set the
collation_database=utf8_bin, what was your character_set_database values.
regards
anandkl
On 8/30/07, Harald Vajkonny <[EMAIL PROTECTED]> wrote:
>
> Harald Vajkonny schrieb:
> > In doing this I got another idea: Does anybody know the difference
> > between the collatio
On Thu, 30 Aug 2007 11:41:14 +0200, "Olav Mørkrid"
<[EMAIL PROTECTED]> said:
> if a table column is supposed to contain text in iso-8859-1, but utf-8
> encoding have snuck in on a few rows by mistake, how are these rows
> converted into iso-8859-1?
>
> what i am looking for is something like this
Hi friends,
I need to make a calendar with some events.
I have created an events table with the parameters like:
eventid
event_from
event_till
recurring
recurring_after_day
event_type
userid
and so on.
My problem is to prepare a query which can give me events on a particular
day or rather all days
Hi Keith,
Thanks for the info,
Actually, we are moving our db to a new database center, so during one point
of time, we will not have access to the old data center (master db), so i
want to set up a second slave, and at a specific point in time, make the
second slave, a stand alone master db.
rega
Ananda,
The answer to your question is very simple actually, but there is some
subtleties that you need to think of.
To stop the slave from getting replication data from the master just issue a
"stop slave" command. I would also recommend that you run a "reset master"
command in addition. Th
Harald Vajkonny schrieb:
> In doing this I got another idea: Does anybody know the difference
> between the collations utf8_general_ci, utf8_unicode_ci and utf8_bin?
> I'll try these first and then get back to you about the results.
>
That was it. If I choose utf8_bin as collation everything wor
Dušan Pavlica schrieb:
> What's the charset and collation of your primary field in the table?
With which command do I get the charset and collation information of a
single field in a table? SHOW CREATE TABLE returns:
...
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
But I believe it is utf8, because when
Mariella,
Mariella Petrini wrote:
Hi All,
I have been using MySQL 5.1.x with InnoDB and Raw
Devices.
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=/dev/hdd1:3Gnewraw;/dev/hdd2:2Gnewraw
...
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=/dev/hdd1:5Graw;/dev/hdd2:2Graw
Is th
Harald Vajkonny napsal(a):
Dušan Pavlica schrieb:
Try to convert file to latin1, if it's possible, create database with
latin1 charset, create table with required structure (you can set utf8
charset to string fields ) and then load data.
I can not convert the file into latin1, because
Dušan Pavlica schrieb:
> Try to convert file to latin1, if it's possible, create database with
> latin1 charset, create table with required structure (you can set utf8
> charset to string fields ) and then load data.
I can not convert the file into latin1, because it is multilingual (i.e.
Europea
Ananda Kumar schrieb:
> strange. did u exit and reconnect and did the select?
>
Yes, I tried it once more. I have to put the USE command before I change
session settings to "latin" to make it work without error (otherwise I
still get the duplicate message). But even after exiting I get the
natio
Harald Vajkonny napsal(a):
Ananda Kumar schrieb:
strange. did u exit and reconnect and did the select?
Yes, I tried it once more. I have to put the USE command before I change
session settings to "latin" to make it work without error (otherwise I
still get the duplicate message). Bu
Ananda Kumar schrieb:
> strange. did u exit and reconnect and did the select?
>
Yes, I tried it once more. I have to put the USE command before I change
session settings to "latin" to make it work without error (otherwise I
still get the duplicate message). But even after exiting I get the
nati
strange. did u exit and reconnect and did the select?
On 8/30/07, Harald Vajkonny <[EMAIL PROTECTED]> wrote:
>
> Ananda Kumar schrieb:
> > I used the latin collation and latin db character set, to load data
> > similar to you, and we got this done correctly.
> >
> > If your inserting multi byte da
> Does anybody know how I restart my mysql-server with the correct
> character and collation settings, if this is the cause for my problem,
> or if there might be any other reason for it. My mysql version is
> 5.0.26-12, running on a Suse Linux 10.2.
>
Meanwhile I managed to change the server s
Ananda Kumar schrieb:
> I used the latin collation and latin db character set, to load data
> similar to you, and we got this done correctly.
>
> If your inserting multi byte data, then u need to set the above
> parameters. This was one of the solutions give by mysql, i am not able
> to get the u
I used the latin collation and latin db character set, to load data similar
to you, and we got this done correctly.
If your inserting multi byte data, then u need to set the above parameters.
This was one of the solutions give by mysql, i am not able to get the url. I
will search my notes and get
if a table column is supposed to contain text in iso-8859-1, but utf-8
encoding have snuck in on a few rows by mistake, how are these rows
converted into iso-8859-1?
what i am looking for is something like this:
update mytable set mycolumn = utf8toiso88591(mycolumn) where id
between 500 and 600;
Edward Kay napsal(a):
I would like to import data from a utf8-coded comma seperated file. I
created my database with "DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci" and I started my mysql-client with the
--default-character-set=utf8 option. Nevertheless, when I input primary
key fields, whic
Edward Kay schrieb:
> Try using the SET NAMES 'utf8' statement [1] to tell MySQL that your client
> is sending data in UTF-8. I believe that as your server is latin1, it will
> assume this is the character set used by the command line client.
>
> [1] http://dev.mysql.com/doc/refman/5.0/en/charset-c
> I would like to import data from a utf8-coded comma seperated file. I
> created my database with "DEFAULT CHARACTER SET utf8 COLLATE
> utf8_general_ci" and I started my mysql-client with the
> --default-character-set=utf8 option. Nevertheless, when I input primary
> key fields, which differ only
Ananda Kumar schrieb:
> Before you import at the mysql prompt set below variables and then try
> again to load
>
> set session max_error_count=50;
> set session collation_database=latin1_swedish_ci;
> set session character_set_database=latin1;
This is not what I need, because I use utf8 as we
Before you import at the mysql prompt set below variables and then try again
to load
set session max_error_count=50;
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 8/30/07, Harald Vajkonny <[EMAIL PROTECTED]> wrote:
>
> Hello,
Hello,
I would like to import data from a utf8-coded comma seperated file. I
created my database with "DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci" and I started my mysql-client with the
--default-character-set=utf8 option. Nevertheless, when I input primary
key fields, which differ only in
[EMAIL PROTECTED] wrote:
Hey Peoples... How do I get myself of this email list? Thanks
It's a very complicated 2 step process:
1) learn to read.
2) follow the directions.
Every email list in the civilized world has instructions on how to
unsubscribe at the bottom or top of EVERY message!
Hi All,
We have one master and two slave dbs.
Now we want one of the slaves to work as a stand alone master db, so what
are the steps that i need to take to make one of the slaves as a stand alone
master db.
regards
anandkl
28 matches
Mail list logo
