Hi Ananda
that worked fine:
mysql> alter table suomi_contacts2 modify history longtext character set
utf8 collate utf8_bin;
Query OK, 6327 rows affected (0.34 sec)
Records: 6327 Duplicates: 0 Warnings: 0
mysql>
mysql> update suomi_contacts2 set history = concat(now(), ' ', ''
,'concerne: u
Hi Ananda
not sofar. But if you recommend it, i will give it a try.
thanks so much.
suomi
On 2010-08-31 15:41, Ananda Kumar wrote:
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql mailto:my...@ayni.com>>
On 2010-08-31 15:17, Ananda Kumar wro
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql
> On 2010-08-31 15:17, Ananda Kumar wrote:
> > desc suomi_contacts2;
>
> mysql> desc suomi_contacts2;
>
> +--+--+--+-+---+
On 2010-08-31 15:17, Ananda Kumar wrote:
> desc suomi_contacts2;
mysql> desc suomi_contacts2;
+--+--+--+-+---+-+
| Field| Type | Null | Key | Default |
Extra
can u please give the output of
desc suomi_contacts2;
2010/8/31 mysql
> Hi Ananda
>
> table structure is:
>
> mysql> show full columns from suomi_contacts2;
>
> +--+--+---+--+-+---+-+-
Hi Ananda
table structure is:
mysql> show full columns from suomi_contacts2;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collation
can u please list out the table structure...as collation can also be set at
column level
regards
anandkl
On Tue, Aug 31, 2010 at 6:00 PM, mysql wrote:
> Hi listers
> mysql server here is
>
> mysql-server-5.1.48-2.fc13.x86_64
>
> this morning i created a message with a literal string in chinese
Hi listers
mysql server here is
mysql-server-5.1.48-2.fc13.x86_64
this morning i created a message with a literal string in chinese in it.
the messages in the application i used are stored in a mysql database,
when you submit them, like in a "sent" folder.
With this chinese literal in it, i,
Hi,
I know about CONVERT but I wanted to check character set of 'tt' column
and this result use in CONVERT. Something like CONVERT(id USING
CHARSET(Name))
which doesn't work.
It wont. the syntax is -- CONVERT(expr USING transcoding_name); its the
name of the transcode and not an expr.
I j
binary' is expected.
if u want the resultant as:
mysql> select charset(concat(tt,CONVERT(id USING latin1))) from test;
Thanks
ViSolve DB Team
- Original Message - From: "Dušan Pavlica" <[EMAIL PROTECTED]>
To: "list mysql"
Sent: Wednesday, January
set(concat(tt,CONVERT(id USING latin1))) from test;
Thanks
ViSolve DB Team
- Original Message -
From: "Dušan Pavlica" <[EMAIL PROTECTED]>
To: "list mysql"
Sent: Wednesday, January 31, 2007 5:31 PM
Subject: CONCAT(int_col, string_col) and charset and collation proble
Hi,
I'm using MySQL 4.1.15, WinXP and my problem is that
SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable;
always returns charset 'binary' and I need resulting charset to be same
as a charset of a string_column because I don't want to look for
charset of a column whenever I have t
Actually, I did a full backup, uninstalled everything, installed a clean
4.1.11 and restored the backup
The data seems to be fine. The funny thing is that if i change one of
the inners for a left everything works fine! I think it's a bug, and an
ugly one...
Andrés Villanueva
Gleb Paharenko
Is it possible your data was changed during upgrade? How
have you performed it?
Andr$s Villanueva <[EMAIL PROTECTED]> wrote:
> Hi! thanks for your response.
>
> This are the values of the variables you asked for:
>
> collation_connection: utf8_general_ci
> collation_database: utf8
Hi! thanks for your response.
This are the values of the variables you asked for:
collation_connection: utf8_general_ci
collation_database: utf8_general_ci
collation_server: utf8_general_ci
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_results:
Hello.
Please, send the output of the following statements:
show variables like '%colla%';
show variables like '%char%';
Andr$s Villanueva <[EMAIL PROTECTED]> wrote:
> Anyone??
>
> Original Message
>
> The tables are now entirely in utf8, and that is also
2005 15:33
To: mysql@lists.mysql.com
Subject: Collation problems or messed joins?
Hi everyone! I'm havng the weirdest problem with mysql.
I had v1.1.07 and everything worked like a charm. But it turns out
that
we had the need to move everything to UTF8 (until then, only the
columns
in
ent
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swithcboard)
Tel: 0118 902 9099 (direct)
Web: www.alchemetrics.co.uk
Email: [EMAIL PROTECTED]
-Original Message-
From: Andrés Villanueva [mailto:[EMAIL PROTECTED]
Sent: 03 May 2005 15:33
To: mysql@lists.mysql.com
Subject: Collatio
)
Web: www.alchemetrics.co.uk
Email: [EMAIL PROTECTED]
> -Original Message-
> From: Andrés Villanueva [mailto:[EMAIL PROTECTED]
> Sent: 03 May 2005 15:33
> To: mysql@lists.mysql.com
> Subject: Collation problems or messed joins?
>
> Hi everyone! I'm havng the weirdest prob
Hi everyone! I'm havng the weirdest problem with mysql.
I had v1.1.07 and everything worked like a charm. But it turns out that
we had the need to move everything to UTF8 (until then, only the columns
in russian where set to utf8, and the rest was latin1).
Once we moved everything to utf8, this (
20 matches
Mail list logo
