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\bin>mysql
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]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
<___/ 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
