.
If I start the command line client like this:
mysql -uroot --default-character-set=utf8 -p
Then I get the result that I want. That is, ALL relevant variables are set
to utf8 or utf8_general_ci.
My question: how do I set the default character set in the options file?
What do I have to do to set
to have UTF8 character set
which we already configured in both JIRA and MySQL. However, when I type
mysql --help in
command prompt, it still shows lantin1 for
default-character-set. I'd like to ask how can I change the
default-character-set to UTF8? (I already tried the MySQL server Config
in command prompt, it still shows lantin1 for
default-character-set. I'd like to ask how can I change the
default-character-set to UTF8? (I already tried the MySQL server Config
Wizard)
mysql show variables like char%;
character_set_client| latin1
character_set_connection | latin1
Kittiphum Worachat [EMAIL PROTECTED] wrote:
Victoria Reznichenko wrote:
Starts fine for me from command line:
C:\mysql\binmysqld-nt.exe --default-character-set=tis620 --standalone --console
040122 14:36:50 InnoDB: Started; log sequence number 0 43634
mysqld-nt.exe: ready for connections
with
--default-character-set option:
http://www.mysql.com/doc/en/Charset-server.html
What exactly doesn't work for you?
Thanks but it still not work if I start like that
mysqld-nt --default-character-set =tis620
server alway gone away (can not start service ) it work fine if I set
to latin-1
, you should start mysqld with
--default-character-set option:
http://www.mysql.com/doc/en/Charset-server.html
What exactly doesn't work for you?
Thanks but it still not work if I start like that
mysqld-nt --default-character-set =tis620
Starts fine for me from command line:
C:\mysql
Victoria Reznichenko wrote:
Starts fine for me from command line:
C:\mysql\binmysqld-nt.exe --default-character-set=tis620 --standalone --console
040122 14:36:50 InnoDB: Started; log sequence number 0 43634
mysqld-nt.exe: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
Hi.
Try to set character set to other not latin1 with MySQL 5 (windows
binary) it not work can some one tell me how to do this.
Thanks
Dr.K
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Kittiphum Worachat [EMAIL PROTECTED] wrote:
Try to set character set to other not latin1 with MySQL 5 (windows
binary) it not work can some one tell me how to do this.
If you want to set character set on the server level, you should start mysqld with
--default-character-set option
Have you tried this setting in the my.cnf file?
[mysqld]
default-character-set=latin5
Good luck
Hi,
I am from turkey.I have used mysql for a longtime.I downloaded
mysql_win 4.0.16 and then setup,But I can't startup mysql with latin5
support.What can I do..?
How can I recompile mysql
Description:
When i using default-character-set tis620 (Thai sort order) mysql server
has been crash and then I test to use latin1 can work fine but can't
sort order in thai language.
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:apples
Organization
Hi!
On Jul 31, Kittiphum Worachat wrote:
Hi.
With MySQL 4.1.0 alpha when I try to set default character set to tis620
MySQL start OK but have crash every time when perform to tun query (with
default_character_set=latin1 it never got error) and with MySQL 4.0.14 it
can do with out any
Hi.
With MySQL 4.1.0 alpha when I try to set default character set to tis620
MySQL start OK but have crash every time when perform to tun query (with
default_character_set=latin1 it never got error) and with MySQL 4.0.14 it
can do with out any error.
With MySQL 4.1.0 alpha what GUI to use
To perform correct ORDER BY I need to use win1251 charset.
I know that this can be set from my.cfg or in the my.ini:
[mysqld]
default-character-set=win1251
The problem is that I cant use this because I have limited account on
my hosting provider's server (I can't restart the server and I even
On Wednesday 12 February 2003 13:49, Mirko wrote:
To perform correct ORDER BY I need to use win1251 charset.
I know that this can be set from my.cfg or in the my.ini:
[mysqld]
default-character-set=win1251
The problem is that I cant use this because I have limited account on
my hosting
Hello there...
I have a problem with sort order. I use greek and
english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart the demon but the problem still exist.
I have 3.23.49
At 10:23 + 11/6/02, nick gatsis wrote:
Hello there...
I have a problem with sort order. I use greek and
english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart the demon
I have a table within turkish characters.
I know which set I must use: latin5
But I couldn' t set it.
Thanks
SQL,Sql,sql
Edakom Internet Sorumlusu
Gokce Akkaya
-
Before posting, please check:
Gokce,
Friday, April 19, 2002, 12:51:34 PM, you wrote:
GA I have a table within turkish characters.
GA I know which set I must use: latin5
GA But I couldn' t set it.
Run mysqld with --default-character-set=latin5 option or edit my.cnf.
Look at:
http://www.mysql.com/doc/C/h
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
éÌØÑ,
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
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
Hi
there is no UTF-8 possibility for
--default-character-set mysqld starting option.
How can I tell mysql to send to clients utf-8 if everything on the database is latin-1
?
if
--default-character-set=UTF-8 would exists in shared/charsets,
does it mean I have to recode all the content
23 matches
Mail list logo