problems with default-character-set=cp1251
Hi. I use mysql 3.26.47, established on Windows 2000 Server Russian. After I set property - default-character-set = cp1251, web-server on a beginning to give out a massage - File ' c:\mysql \\ share\charsets \?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a compiled character set and is not specified in the' c:\mysql \\ share\charsets\Index ' file If to set default-character-set = latin1, all ok. But I for correct sorting need cp1251. What it is necessary to make? It is my file my.ini from the catalogue winnt # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking character-sets-dir=c:/server/usr/mysql/share/charsets/ default-character-set=cp1251 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/server/usr/mysql/ datadir =C:/server/usr/mysql/data # Uncomment the following rows if you are using InnoDB tables # Create the directories ibdata and iblogs before to start the server. # If necessary, modify the size of the files #innodb_data_file_path = ibdata1:200M #innodb_data_home_dir = c:\ibdata #set-variable = innodb_mirrored_log_groups=1 #innodb_log_group_home_dir = c:\iblogs #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=30M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_arch_dir = c:\iblogs #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=80M #set-variable=lower_case_table_names =0 #set-variable = innodb_additional_mem_pool_size=10M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 # Uncomment the following row if you are using a Max server and you don't want the # InnoDb tables #skip-innodb [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb [WinMySQLAdmin] Server=C:/server/usr/mysql/bin/mysqld-max-nt.exe Best regards, Ilya mailto:[EMAIL PROTECTED] http://www.ilysha.i-am.ru - 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
problems with default-character-set=cp1251
éÌØÑ, Wednesday, February 13, 2002, 8:48:52 AM, you wrote: éåë Hi. éåë I use mysql 3.26.47, established on Windows 2000 Server Russian. éåë After I set property - default-character-set = cp1251, web-server on a éåë beginning to give out a massage - File ' c:\mysql \\ share\charsets éåë \?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a éåë compiled character set and is not specified in the' c:\mysql \\ share\charsets\Index ' file éåë If to set default-character-set = latin1, all ok. But I for correct éåë sorting need cp1251. What it is necessary to make? éåë It is my file my.ini from the catalogue winnt [skip] Find your answers at: http://www.mysql.com/doc/P/r/Problems_with_character_sets.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: problems with default-character-set=cp1251
At 09:48 13/02/2002 +0300, =?koi8-r?B?6czY0SDl18fFztjF18neIOvP0s/Cz9c=?= wrote: Hi! I did the test with default-character-set=cp1251 and was not be able to repeat your problem: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\cd\server\usr\mysql\bin C:\server\usr\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.47-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like %character%; ++-- ---+ | Variable_name | Value | ++-- ---+ | character_set | cp1251 | | 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 hunga rian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | ++-- ---+ 2 rows in set (0.06 sec) Regards, Miguel Hi. I use mysql 3.26.47, established on Windows 2000 Server Russian. After I set property - default-character-set = cp1251, web-server on a beginning to give out a massage - File ' c:\mysql \\ share\charsets \?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a compiled character set and is not specified in the' c:\mysql \\ share\charsets\Index ' file If to set default-character-set = latin1, all ok. But I for correct sorting need cp1251. What it is necessary to make? It is my file my.ini from the catalogue winnt # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking character-sets-dir=c:/server/usr/mysql/share/charsets/ default-character-set=cp1251 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/server/usr/mysql/ datadir =C:/server/usr/mysql/data # Uncomment the following rows if you are using InnoDB tables # Create the directories ibdata and iblogs before to start the server. # If necessary, modify the size of the files #innodb_data_file_path = ibdata1:200M #innodb_data_home_dir = c:\ibdata #set-variable = innodb_mirrored_log_groups=1 #innodb_log_group_home_dir = c:\iblogs #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=30M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_arch_dir = c:\iblogs #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=80M #set-variable=lower_case_table_names =0 #set-variable = innodb_additional_mem_pool_size=10M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 # Uncomment the following row if you are using a Max server and you don't want the # InnoDb tables #skip-innodb [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb [WinMySQLAdmin] Server=C:/server/usr/mysql/bin/mysqld-max-nt.exe Best regards, Ilya mailto:[EMAIL PROTECTED] http://www.ilysha.i-am.ru - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__