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]
