This Report was made using the WinMySQLadmin 1.0 Tool 2001/02/22 07:34:49 Description : When using MyQDBC with Delphi TTable components and using the table names in uppercase the size of character fields is reported wrong as 128. I cannot change the table names of all TTable components to lowercase in the whole app. No other SQL database app. has problems with that. What should we do? How-To-Repeat : Fix : Synopsis : Submitter-Id : Originator : Organization : MySQL support : [none | licence | email support | extended email support ] Severity : [non-critical | serious | critical ] Priority : [low | medium | high ] Category : [mysqld, mysql client, C, PHP, PERL, ...] Class : [ sw-bug | doc-bug | change-request | support ] OS Platform : Windows NT detected Machine description: Compiler : VC++ 6.0 Architecture : i686 Total Memory : 130.612 MB RAM My.ini File [mysqld] basedir=C:/mysql datadir=C:/mysql/data Server Status Values Server Info 3.23.33 Host Info localhost via TCP/IP Client Info 3.23.22-beta Proto Info 10 Aborted_clients 1 Aborted_connects 2 Bytes_received 0 Bytes_sent 0 Connections 17 Created_tmp_disk_tables 0 Created_tmp_tables 1 Created_tmp_files 0 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_delete 1 Handler_read_first 287 Handler_read_key 47487 Handler_read_next 47190 Handler_read_prev 0 Handler_read_rnd 450214 Handler_read_rnd_next 495554 Handler_update 0 Handler_write 941580 Key_blocks_used 7764 Key_read_requests 4178181 Key_reads 73 Key_write_requests 991906 Key_writes 991905 Max_used_connections 3 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables 20 Open_files 31 Open_streams 0 Opened_tables 755 Questions 996194 Select_full_join 0 Select_full_range_join 0 Select_range 0 Select_range_check 0 Select_scan 12 Slave_running OFF Slave_open_temp_tables 0 Slow_launch_threads 0 Slow_queries 10 Sort_merge_passes 0 Sort_range 0 Sort_rows 450214 Sort_scan 11 Table_locks_immediate 989835 Table_locks_waited 0 Threads_cached 0 Threads_created 16 Threads_connected 1 Threads_running 1 Uptime 56562 Variables Values ansi_mode OFF back_log 50 basedir c:\mysql\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk 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 ON connect_timeout 5 datadir c:\mysql\data\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_gemini NO have_innobase NO have_isam YES have_raid NO have_ssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8388600 language c:\mysql\share\english\ large_files_support ON log OFF log_update OFF log_bin OFF log_slave_updates 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_tmp_tables 32 max_write_lock_count 4294967295 myisam_recover_options OFF myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file c:\mysql\data\gemsbok.pid port 3306 protocol_version 10 record_buffer 131072 query_buffer_size 0 safe_show_database OFF server_id 0 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket MySQL sort_buffer 2097144 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 timezone South Africa Standard Time tmp_table_size 1048576 tmpdir c:\winnt\temp\ version 3.23.33 wait_timeout 28800 Last Lines from Err File 010221 16:56:29 Aborted connection 8 to db: 'Aquabase' user: 'root' host: `gemsbok' (Unknown error) MySql: ready for connections 010221 15:45:54 Aborted connection 220 to db: 'North' user: 'immo' host: `gemsbok' (Unknown error) 010221 15:45:54 Aborted connection 222 to db: 'North' user: 'root' host: `gemsbok' (Unknown error) 010221 15:45:28 MySql: Normal shutdown 010221 15:44:57 Aborted connection 221 to db: 'North' user: 'root' host: `gemsbok' (Unknown error) 010221 15:44:33 Aborted connection 19 to db: 'North' user: 'immo' host: `localhost' (Unknown error) 010221 13:59:58 Aborted connection 109 to db: 'Aquabase' user: 'immo' host: `gemsbok' (Unknown error) 010221 13:59:58 Aborted connection 123 to db: 'North' user: 'immo' host: `gemsbok' (Unknown error) 010221 13:59:46 Aborted connection 24 to db: 'North' user: 'root' host: `localhost' (Unknown error) 010221 11:13:58 Aborted connection 1 to db: 'Aquabase' user: 'immo' host: `localhost' (Unknown error) ections --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
