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 my...@ayni.com 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
Hi Ananda
table structure is:
mysql show full columns from suomi_contacts2;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collation
can u please give the output of
desc suomi_contacts2;
2010/8/31 mysql my...@ayni.com
Hi Ananda
table structure is:
mysql show full columns from suomi_contacts2;
On 2010-08-31 15:17, Ananda Kumar wrote:
desc suomi_contacts2;
mysql desc suomi_contacts2;
+--+--+--+-+---+-+
| Field| Type | Null | Key | Default |
Extra |
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql my...@ayni.com
On 2010-08-31 15:17, Ananda Kumar wrote:
desc suomi_contacts2;
mysql desc suomi_contacts2;
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 my...@ayni.com mailto:my...@ayni.com
On 2010-08-31 15:17,
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:
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:
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
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 the
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
Have you check that the collation for the text columns match the
collation for the table and that you've set UTF8 for the query (set
char set utf8).
Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swithcboard)
Tel: 0118 902 9099 (direct)
Web:
The tables are now entirely in utf8, and that is also the instance's
default.
I'm using the .net dll to connect and the connection string has charset
= utf8.
I'm testing everything with the query browser, and i get the exact same
behaviour.
Again, if anyone wants a script to recreate the tables
Anyone??
Original Message
The tables are now entirely in utf8, and that is also the instance's
default.
I'm using the .net dll to connect and the connection string has charset
= utf8.
I'm testing everything with the query browser, and i get the exact same
behaviour.
Again, if
14 matches
Mail list logo
