Utf8 errors when using mysql odbc 5.1 connector

Hi,

I have the following table filled with utf8 data:

CREATE TABLE `accounts2` (
  `account_id` int(10) unsigned NOT NULL auto_increment,
  `account_name` varchar(250) NOT NULL,
  PRIMARY KEY  (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8

When using the odbc 5.1 (or 3.51) connector I'm not getting utf8 data
correctly back to my client. 
It looks like im getting utf-8 data as ISO, eg. øæå, instead of
æøå. I've tried different table creations with collations etc, but with
no luck.

Any help would be appreciated.

See below for my settings.

Best regards

Kjartan Andreassen

+---------------------------------+-------------------------------------+
| Variable_name 		  | Value				|
+---------------------------------+-------------------------------------+
| auto_increment_increment	  | 1					| 
| auto_increment_offset 	  | 1					| 
| automatic_sp_privileges	  | ON					| 
| back_log			  | 50					| 
| basedir			  | /					| 
| binlog_cache_size		  | 32768				| 
| bulk_insert_buffer_size	  | 8388608				| 
| character_set_client		  | latin1				| 
| character_set_connection	  | latin1				| 
| character_set_database	  | latin1				| 
| character_set_filesystem	  | binary				| 
| character_set_results 	  | latin1				| 
| character_set_server		  | utf8				| 
| character_set_system		  | utf8				| 
| character_sets_dir		  | /usr/share/mysql/charsets/		| 
| collation_connection		  | latin1_swedish_ci			| 
| collation_database		  | latin1_swedish_ci			| 
| collation_server		  | utf8_general_ci			| 
| completion_type		  | 0					| 
| concurrent_insert		  | 1					| 
| connect_timeout		  | 5					| 
| datadir			  | /var/lib/mysql/			| 
| date_format			  | %Y-%m-%d				| 
| datetime_format		  | %Y-%m-%d %H:%i:%s			| 
| default_week_format		  | 0					| 
| delay_key_write		  | ON					| 
| delayed_insert_limit		  | 100 				| 
| delayed_insert_timeout	  | 300 				| 
| delayed_queue_size		  | 1000				| 
| div_precision_increment	  | 4					| 
| engine_condition_pushdown	  | OFF 				| 
| expire_logs_days		  | 0					| 
| flush 			  | OFF 				| 
| flush_time			  | 0					| 
| ft_boolean_syntax		  | + -><()~*:""&|			| 
| ft_max_word_len		  | 84					| 
| ft_min_word_len		  | 2					| 
| ft_query_expansion_limit	  | 20					| 
| ft_stopword_file		  |					| 
| group_concat_max_len		  | 1024				| 
| have_archive			  | YES 				| 
| have_bdb			  | NO					| 
| have_blackhole_engine 	  | YES 				| 
| have_compress 		  | YES 				| 
| have_crypt			  | YES 				| 
| have_csv			  | YES 				| 
| have_dynamic_loading		  | NO					| 
| have_example_engine		  | YES 				| 
| have_federated_engine 	  | YES 				| 
| have_geometry 		  | YES 				| 
| have_innodb			  | YES 				| 
| have_isam			  | NO					| 
| have_merge_engine		  | YES 				| 
| have_ndbcluster		  | DISABLED				| 
| have_openssl			  | NO					| 
| have_ssl			  | NO					| 
| have_query_cache		  | YES 				| 
| have_raid			  | NO					| 
| have_rtree_keys		  | YES 				| 
| have_symlink			  | YES 				| 
| init_connect			  |					| 
| init_file			  |					| 
| init_slave			  |					| 
| innodb_additional_mem_pool_size | 1048576				| 
| innodb_autoextend_increment	  | 8					| 
| innodb_buffer_pool_awe_mem_mb   | 0					| 
| innodb_buffer_pool_size	  | 8388608				| 
| innodb_checksums		  | ON					| 
| innodb_commit_concurrency	  | 0					| 
| innodb_concurrency_tickets	  | 500 				| 
| innodb_data_file_path 	  | ibdata1:10M:autoextend		| 
| innodb_data_home_dir		  |					| 
| innodb_doublewrite		  | ON					| 
| innodb_fast_shutdown		  | 1					| 
| innodb_file_io_threads	  | 4					| 
| innodb_file_per_table 	  | OFF 				| 
| innodb_flush_log_at_trx_commit  | 1					| 
| innodb_flush_method		  |					| 
| innodb_force_recovery 	  | 0					| 
| innodb_lock_wait_timeout	  | 50					| 
| innodb_locks_unsafe_for_binlog  | OFF 				| 
| innodb_log_arch_dir		  |					| 
| innodb_log_archive		  | OFF 				| 
| innodb_log_buffer_size	  | 1048576				| 
| innodb_log_file_size		  | 5242880				| 
| innodb_log_files_in_group	  | 2					| 
| innodb_log_group_home_dir	  | ./					| 
| innodb_max_dirty_pages_pct	  | 90					| 
| innodb_max_purge_lag		  | 0					| 
| innodb_mirrored_log_groups	  | 1					| 
| innodb_open_files		  | 300 				| 
| innodb_rollback_on_timeout	  | OFF 				| 
| innodb_support_xa		  | ON					| 
| innodb_sync_spin_loops	  | 20					| 
| innodb_table_locks		  | ON					| 
| innodb_thread_concurrency	  | 8					| 
| innodb_thread_sleep_delay	  | 10000				| 
| interactive_timeout		  | 28800				| 
| join_buffer_size		  | 131072				| 
| key_buffer_size		  | 8388600				| 
| key_cache_age_threshold	  | 300 				| 
| key_cache_block_size		  | 1024				| 
| key_cache_division_limit	  | 100 				| 
| language			  | /usr/share/mysql/english/		| 
| large_files_support		  | ON					| 
| large_page_size		  | 0					| 
| large_pages			  | OFF 				| 
| lc_time_names 		  | en_US				| 
| license			  | GPL 				| 
| local_infile			  | ON					| 
| locked_in_memory		  | OFF 				| 
| log				  | ON					| 
| log_bin			  | OFF 				| 
| log_bin_trust_function_creators | OFF 				| 
| log_error			  |					| 
| log_queries_not_using_indexes   | OFF 				| 
| log_slave_updates		  | OFF 				| 
| log_slow_queries		  | OFF 				| 
| log_warnings			  | 1					| 
| long_query_time		  | 10					| 
| low_priority_updates		  | OFF 				| 
| lower_case_file_system	  | OFF 				| 
| lower_case_table_names	  | 0					| 
| max_allowed_packet		  | 20970496				| 
| max_binlog_cache_size 	  | 4294967295				| 
| max_binlog_size		  | 1073741824				| 
| max_connect_errors		  | 10					| 
| max_connections		  | 1000				| 
| max_delayed_threads		  | 20					| 
| max_error_count		  | 64					| 
| max_heap_table_size		  | 16777216				| 
| max_insert_delayed_threads	  | 20					| 
| max_join_size 		  | 18446744073709551615		| 
| max_length_for_sort_data	  | 1024				| 
| max_prepared_stmt_count	  | 16382				| 
| max_relay_log_size		  | 0					| 
| max_seeks_for_key		  | 4294967295				| 
| max_sort_length		  | 1024				| 
| max_sp_recursion_depth	  | 0					| 
| max_tmp_tables		  | 32					| 
| max_user_connections		  | 0					| 
| max_write_lock_count		  | 4294967295				| 
| multi_range_count		  | 256 				| 
| myisam_data_pointer_size	  | 6					| 
| myisam_max_sort_file_size	  | 2147483647				| 
| myisam_recover_options	  | OFF 				| 
| myisam_repair_threads 	  | 1					| 
| myisam_sort_buffer_size	  | 8388608				| 
| myisam_stats_method		  | nulls_unequal			| 
| ndb_autoincrement_prefetch_sz   | 32					| 
| ndb_force_send		  | ON					| 
| ndb_use_exact_count		  | ON					| 
| ndb_use_transactions		  | ON					| 
| ndb_cache_check_time		  | 0					| 
| ndb_connectstring		  |					| 
| net_buffer_length		  | 16384				| 
| net_read_timeout		  | 30					| 
| net_retry_count		  | 10					| 
| net_write_timeout		  | 60					| 
| new				  | OFF 				| 
| old_passwords 		  | OFF 				| 
| open_files_limit		  | 5000				| 
| optimizer_prune_level 	  | 1					| 
| optimizer_search_depth	  | 62					| 
| port				  | 3306				| 
| preload_buffer_size		  | 32768				| 
| profiling			  | OFF 				| 
| profiling_history_size	  | 15					| 
| protocol_version		  | 10					| 
| query_alloc_block_size	  | 8192				| 
| query_cache_limit		  | 1048576				| 
| query_cache_min_res_unit	  | 4096				| 
| query_cache_size		  | 0					| 
| query_cache_type		  | ON					| 
| query_cache_wlock_invalidate	  | OFF 				| 
| query_prealloc_size		  | 8192				| 
| range_alloc_block_size	  | 2048				| 
| read_buffer_size		  | 131072				| 
| read_only			  | OFF 				| 
| read_rnd_buffer_size		  | 262144				| 
| relay_log_purge		  | ON					| 
| relay_log_space_limit 	  | 0					| 
| rpl_recovery_rank		  | 0					| 
| secure_auth			  | OFF 				| 
| secure_file_priv		  |					| 
| server_id			  | 0					| 
| skip_external_locking 	  | ON					| 
| skip_networking		  | OFF 				| 
| skip_show_database		  | OFF 				| 
| slave_compressed_protocol	  | OFF 				| 
| slave_load_tmpdir		  | /tmp/				| 
| slave_net_timeout		  | 3600				| 
| slave_skip_errors		  | OFF 				| 
| slave_transaction_retries	  | 10					| 
| slow_launch_time		  | 2					| 
| socket			  | /var/lib/mysql/mysql.sock		| 
| sort_buffer_size		  | 2097144				| 
| sql_big_selects		  | ON					| 
| sql_mode			  |					| 
| sql_notes			  | ON					| 
| sql_warnings			  | OFF 				| 
| ssl_ca			  |					| 
| ssl_capath			  |					| 
| ssl_cert			  |					| 
| ssl_cipher			  |					| 
| ssl_key			  |					| 
| storage_engine		  | MyISAM				| 
| sync_binlog			  | 0					| 
| sync_frm			  | ON					| 
| system_time_zone		  | CET 				| 
| table_cache			  | 64					| 
| table_lock_wait_timeout	  | 50					| 
| table_type			  | MyISAM				| 
| thread_cache_size		  | 0					| 
| thread_stack			  | 126976				| 
| time_format			  | %H:%i:%s				| 
| time_zone			  | SYSTEM				| 
| timed_mutexes 		  | OFF 				| 
| tmp_table_size		  | 33554432				| 
| tmpdir			  | /tmp/				| 
| transaction_alloc_block_size	  | 8192				| 
| transaction_prealloc_size	  | 4096				| 
| tx_isolation			  | REPEATABLE-READ			| 
| updatable_views_with_limit	  | YES 				| 
| version			  | 5.0.45-community-log		| 
| version_comment		  | MySQL Community Edition (GPL)	| 
| version_compile_machine	  | i686				| 
| version_compile_os		  | pc-linux-gnu			| 
| wait_timeout			  | 28800				| 
+---------------------------------+-------------------------------------+
-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]