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 wrote:
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_general_ci
collation_server: utf8_general_ci
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_results: NULL
character_set_server: utf8
character_set_system: utf8
These were taken from a query inside the app. From the query browser the
only difference is:
character_set_results: utf8
Anyway, the same query has the same results in the app and the query
browser. The app is using the .net connector
Thanks
Andr$s Villanueva
Gleb Paharenko wrote:
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 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 with some data, I
can send it to you instantly.
Thanks
Andr$s Villanueva
Kevin Cowley wrote:
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: www.alchemetrics.co.uk
Email: [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]