I'm trying to get a C#/.Net page to work with MySQL (through MySQL Connector/Net), but I'm having some problems with special characters. In the MySQL command prompt, everything displays OK, and all character set variables are set to latin1 and Swedish collation, except system, which is UTF8, but data outputted in html through .Net mangles the Swedish åäö characters. I've tried just about every combination of character set string conversion (through system.text.encoding.convert) and document headers, but I'm not getting anywhere. I'd prefer UTF8 output, but anything which works will do.
![[H]ard|Forum](/styles/hardforum/xenforo/logo_dark.png){kind=logo}
-
Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.
.Net, MySQL and character sets...
- Thread starter Nevermind
- Start date
calebb
[H]F Junkie
- Joined
- Mar 26, 2000
- Messages
- 8,758
Check out this blog post:
http://www.saiweb.co.uk/mysql/mysql-forcing-utf-8-compliance-for-all-connections
This show's some SQL commands you can add to your my.cnf that will execute every time you connect (as a non-root) user.
init_connect='SET collation_connection = utf8_general_ci; SET NAMES utf8;'
Don't forget to restart mysql after you make this change.
http://www.saiweb.co.uk/mysql/mysql-forcing-utf-8-compliance-for-all-connections
This show's some SQL commands you can add to your my.cnf that will execute every time you connect (as a non-root) user.
init_connect='SET collation_connection = utf8_general_ci; SET NAMES utf8;'
Don't forget to restart mysql after you make this change.