Re: forwarded message from ZMan ZMan

am 16.07.2002 15:34:04 von Alexander Barkov

Hi!

According to "character_set" value in "Variables Values"
section of this report I can see that server is running
with latin1 charset, so it uses latin1 sorting order.
You have to restart server with "hebrew" charset.

> Subject:
> the MySQL's Hebrew Sorting-order is just wrong
> From:
> ZMan ZMan
> Date:
> Mon, 15 Jul 2002 19:47:54 +0200
> To:
> bugs@lists.mysql.com
>
>
>
>
> This Report was made using the WinMySQLAdmin 1.4 Tool
>
> 15/07/2002 2:35:46
>
> Description : the Hebrew Sorting-order is just wrong
> How-To-Repeat :
> Use This Dump to Create a Table with Hebrew Letters (on a MySQLd with
> Hebrew Charset...) ->
> # phpMyAdmin MySQL-Dump (http://www.phpmyadmin.net/ (download page))
>
> #
> # Table structure for table `hebrew_test`
> #
>
> DROP TABLE IF EXISTS hebrew_test;
>
> CREATE TABLE hebrew_test (
> id int(6) unsigned NOT NULL auto_increment,
> text_col char(3) NOT NULL default '',
> PRIMARY KEY (id)
> ) TYPE=MyISAM;
>
> #
> # Dumping data for table `hebrew_test`
> #
>
> INSERT INTO hebrew_test (id, text_col) VALUES (1, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (2, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (3, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (4, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (5, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (6, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (7, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (8, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (9, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (10, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (11, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (12, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (13, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (14, '×××');
> INSERT INTO hebrew_test (id, text_col) VALUES (15, '××× ');
> INSERT INTO hebrew_test (id, text_col) VALUES (16, '×× ×¡');
> INSERT INTO hebrew_test (id, text_col) VALUES (17, '× ×¡×¢');
> INSERT INTO hebrew_test (id, text_col) VALUES (18, '×¡×¢×£');
> INSERT INTO hebrew_test (id, text_col) VALUES (19, '×¢×£×¤');
> INSERT INTO hebrew_test (id, text_col) VALUES (20, '×£×¤×¥');
> INSERT INTO hebrew_test (id, text_col) VALUES (21, '×¤×¥×¦');
> INSERT INTO hebrew_test (id, text_col) VALUES (22, '×¥×¦×§');
> INSERT INTO hebrew_test (id, text_col) VALUES (23, '×¦×§×¨');
> INSERT INTO hebrew_test (id, text_col) VALUES (24, '×§×¨×©');
> INSERT INTO hebrew_test (id, text_col) VALUES (25, '×¨×©×ª');
> INSERT INTO hebrew_test (id, text_col) VALUES (26, '×©×ª×ª');
> INSERT INTO hebrew_test (id, text_col) VALUES (27, '×ª×ª×ª');
>
> and afterwards Run this Query on this Table [ SELECT id,text_col FROM
> hebrew_test ORDER BY text_col ASC ] - now, the ID# represents the Right
> Sorting-order - so you'll notice the MySQL hebrew sorting-order is just
> wrong !.
> Fix : just tell me what how should i help you fixing this
> (because i indeed have no idea)
> Synopsis : the Hebrew Sorting-order is just wrong
> Submitter-Id : 007 (nope ! ;)
> Originator : Moran Zaltsman
> Organization : Jane & John Doe Co.
> MySQL support : none
> Severity : non-critical
> Priority : low
> Category : mysqld
> Class : change-request
> OS Platform : Windows 2000 Service Pack 2
> Machine description: AMD Duron 1.0Ghz (@ 1.13Ghz)
> Compiler : VC++ 6.0
> Architecture : i686
> Total Memory : 261616 KB RAM
>
> My.ini File
>
> [mysqld]
> basedir=J:/Program Files/mysql4
> datadir=J:/Program Files/mysql4/data
> log-bin
>
> Server Status Values
>
> Server Info 4.0.2-alpha-nt-log
> Host Info localhost via TCP/IP
> Client Info 4.0.2-alpha
> Proto Info 10
> Aborted_clients 0
> Aborted_connects 0
> Bytes_received 0
> Bytes_sent 0
> Com_admin_commands 0
> Com_alter_table 0
> Com_analyze 0
> Com_backup_table 0
> Com_begin 19
> Com_change_db 237
> Com_change_master 0
> Com_check 0
> Com_commit 19
> Com_create_db 1
> Com_create_function 0
> Com_create_index 0
> Com_create_table 62
> Com_delete 0
> Com_delete_multi 0
> Com_drop_db 2
> Com_drop_function 0
> Com_drop_index 0
> Com_drop_table 66
> Com_flush 0
> Com_grant 0
> Com_ha_close 0
> Com_ha_open 0
> Com_ha_read 0
> Com_insert 934
> Com_insert_select 0
> Com_kill 0
> Com_load 0
> Com_load_master_data 0
> Com_load_master_table 0
> Com_lock_tables 0
> Com_optimize 0
> Com_purge 0
> Com_rename_table 0
> Com_repair 0
> Com_replace 0
> Com_replace_select 0
> Com_reset 0
> Com_restore_table 0
> Com_revoke 0
> Com_rollback 0
> Com_select 708
> Com_set_option 62
> Com_show_binlog_events 0
> Com_show_binlogs 0
> Com_show_create 62
> Com_show_databases 15
> Com_show_fields 0
> Com_show_grants 0
> Com_show_keys 0
> Com_show_logs 0
> Com_show_master_status 0
> Com_show_new_master 0
> Com_show_open_tables 0
> Com_show_processlist 1
> Com_show_slave_hosts 0
> Com_show_slave_status 0
> Com_show_status 12
> Com_show_tables 168
> Com_show_variables 56
> Com_slave_start 0
> Com_slave_stop 0
> Com_truncate 0
> Com_unlock_tables 0
> Com_update 0
> Connections 74
> Created_tmp_disk_tables 70
> Created_tmp_tables 186
> Created_tmp_files 0
> Delayed_insert_threads 0
> Delayed_writes 0
> Delayed_errors 0
> Flush_commands 1
> Handler_commit 0
> Handler_delete 0
> Handler_read_first 73
> Handler_read_key 7405
> Handler_read_next 606
> Handler_read_prev 0
> Handler_read_rnd 5072
> Handler_read_rnd_next 85000
> Handler_rollback 0
> Handler_update 0
> Handler_write 14173
> Key_blocks_used 147
> Key_read_requests 12988
> Key_reads 43
> Key_write_requests 3057
> Key_writes 3118
> Max_used_connections 2
> Not_flushed_key_blocks 0
> Not_flushed_delayed_rows 0
> Open_tables 11
> Open_files 23
> Open_streams 0
> Opened_tables 480
> Questions 2496
> Rpl_status NULL
> Select_full_join 261
> Select_full_range_join 0
> Select_range 38
> Select_range_check 0
> Select_scan 192
> Slave_open_temp_tables 0
> Slave_running OFF
> Slow_launch_threads 0
> Slow_queries 0
> Sort_merge_passes 0
> Sort_range 23
> Sort_rows 5072
> Sort_scan 231
> Table_locks_immediate 2851
> Table_locks_waited 0
> Threads_cached 0
> Threads_created 73
> Threads_connected 1
> Threads_running 1
> Uptime 22219
>
> Variables Values
>
> back_log 50
> basedir J:\Program Files\mysql4\
> binlog_cache_size 32768
> character_set latin1
> character_sets latin1 big5 czech euc_kr gb2312 gbk
> latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7
> cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek
> win1250 croat cp1257 latin5
> concurrent_insert OFF
> connect_timeout 5
> datadir J:\Program Files\mysql4\data\
> delay_key_write OFF
> delayed_insert_limit 100
> delayed_insert_timeout 300
> delayed_queue_size 1000
> flush OFF
> flush_time 1800
> ft_min_word_len 4
> ft_max_word_len 254
> ft_max_word_len_for_sort 20
> ft_boolean_syntax + -><()~*:""&|
> have_bdb NO
> have_innodb NO
> have_isam YES
> have_raid NO
> have_symlink YES
> have_openssl NO
> have_query_cache NO
> init_file interactive_timeout 28800
> join_buffer_size 131072
> key_buffer_size 8388600
> language J:\Program Files\mysql4\share\english\
> large_files_support ON
> log OFF
> log_update OFF
> log_bin ON
> log_slave_updates OFF
> log_slow_queries OFF
> long_query_time 10
> low_priority_updates OFF
> lower_case_table_names 1
> max_allowed_packet 1048576
> max_binlog_cache_size 4294967295
> max_binlog_size 1073741824
> max_connections 100
> max_connect_errors 10
> max_delayed_threads 20
> max_heap_table_size 16777216
> max_join_size 4294967295
> max_sort_length 1024
> max_user_connections 0
> max_tmp_tables 32
> max_write_lock_count 4294967295
> myisam_bulk_insert_tree_size 8388608
> myisam_max_extra_sort_file_size 256
> myisam_max_sort_file_size 2047
> myisam_recover_options OFF
> myisam_sort_buffer_size 8388608
> named_pipe OFF
> net_buffer_length 16384
> net_read_timeout 30
> net_retry_count 10
> net_write_timeout 60
> open_files_limit 0
> pid_file J:\Program Files\mysql4\data\zman.pid
> port 3306
> protocol_version 10
> record_buffer 131072
> record_rnd_buffer 131072
> rpl_recovery_rank 0
> query_buffer_size 0
> safe_show_database OFF
> server_id 1
> slave_net_timeout 3600
> skip_locking ON
> skip_networking OFF
> skip_show_database OFF
> slow_launch_time 2
> socket MySQL
> sort_buffer 2097144
> sql_mode 0
> table_cache 64
> table_type MYISAM
> thread_cache_size 0
> thread_stack 65536
> transaction_isolation READ-COMMITTED
> timezone Jerusalem Standard Time
> tmp_table_size 33554432
> tmpdir J:\WINNT\TEMP\
> versions 4.0.2-alpha-nt-log , 3.23.51-*
> wait_timeout 28800
>
> Last Lines from Err File
>
> MySql: ready for connections
>
> 020714 20:25:13 MySql: Shutdown Complete
>
> 020714 20:25:13 MySql: Normal shutdown
>
>
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread12186@lists.mysql.com
> To unsubscribe, e-mail
>
>
>
>
> ------------------------------------------------------------ ------------
>
>

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia
<___/ www.mysql.com +7-902-856-80-21

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12187@lists.mysql.com
To unsubscribe, e-mail