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] >>>> >>>> >> >> >> >> >> >> >>>> >>>> >>>> >> >> >> >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
