Jump to content

mysql Incorrect string value: '\x96


Agony

Recommended Posts

So... again - on a wamp setup for test/local inserting the text works.

 

The same text however on production server fails and returns the error.

 

The collation for the column and table is set as utf8mb4_unicode_ci

So is the server connection under general settings.

 

Everything looks identical to the wamp server setup yet it doesn't seem to recognize the 4byte utf8.

 

 

 

mysql is Server version: 5.6.19

windows 2008 R2

 

to make sure i even run (edited):

ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;# For each table:ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;# For each column:ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

and:

character_set_client utf8mb4 character_set_connection utf8mb4 character_set_database utf8mb4 character_set_filesystem binary character_set_results utf8mb4 character_set_server utf8 character_set_system utf8 collation_connection utf8mb4_unicode_ci collation_database utf8mb4_unicode_ci collation_server utf8_general_ci

 

the charachter_set_server for some reason is still utf8 - even to in the my.ini its set to utf8mb4

[client]no-beepdefault-character-set = utf8mb4port=3306[mysql]default-character-set = utf8mb4[mysqld]port=3306datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data"character-set-server = utf8mb4collation-server = utf8mb4_unicode_cidefault-storage-engine=INNODBsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"log-output=FILEgeneral-log=0general_log_file="FALCON578.log"slow-query-log=1slow_query_log_file="FALCON578-slow.log"long_query_time=10log-error="FALCON578.err"max_connections=151query_cache_size=0table_open_cache=2000tmp_table_size=181Mthread_cache_size=10myisam_max_sort_file_size=100Gmyisam_sort_buffer_size=352Mkey_buffer_size=8Mread_buffer_size=64Kread_rnd_buffer_size=256Ksort_buffer_size=256Kinnodb_additional_mem_pool_size=25Minnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=13Minnodb_buffer_pool_size=2Ginnodb_log_file_size=48Minnodb_thread_concurrency=17innodb_autoextend_increment=64innodb_buffer_pool_instances=8innodb_concurrency_tickets=5000innodb_old_blocks_time=1000innodb_open_files=300innodb_stats_on_metadata=0innodb_file_per_table=1innodb_checksum_algorithm=0back_log=80flush_time=0join_buffer_size=256Kmax_allowed_packet=4Mmax_connect_errors=100open_files_limit=4161query_cache_type=0sort_buffer_size=256Ktable_definition_cache=1400binlog_row_event_max_size=8Ksync_master_info=10000sync_relay_log=10000sync_relay_log_info=10000

its in programdata and the mysql folder itself. i restarted mysql after edits.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...