I'm having great trouble setting the default character set to utf8

2005-10-04 Thread jcrowell
all times. 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

Re: How to set utf8 as default character set insteasd of lantin1 ?

2005-01-17 Thread Gleb Paharenko
or bug issues, it needs 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

How to set utf8 as default character set insteasd of lantin1 ?

2005-01-16 Thread Kitty
ql --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 Wizard) mysql> show variables like "char%"; character_set_client|

Re: default character set

2004-01-24 Thread Victoria Reznichenko
Kittiphum Worachat <[EMAIL PROTECTED]> wrote: > Victoria Reznichenko wrote: >>Starts fine for me from command line: >> >>C:\mysql\bin>mysqld-nt.exe --default-character-set=tis620 --standalone --console >>040122 14:36:50 InnoDB: Started; log sequence numbe

Re: default character set

2004-01-22 Thread Kittiphum Worachat
Victoria Reznichenko wrote: Starts fine for me from command line: C:\mysql\bin>mysqld-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: &

Re: default character set

2004-01-22 Thread Victoria Reznichenko
gt;> >>If you want to set character set on the server level, 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

Re: default character set

2004-01-22 Thread Kittiphum Worachat
d 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 se

Re: default character set

2004-01-21 Thread Victoria Reznichenko
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-ch

default character set

2004-01-21 Thread Kittiphum Worachat
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]

Re: default-character-set=latin5

2003-10-31 Thread Daniel Kiss
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 ca

MySQL Crash when using default-character-set tis620 (Thai sort order)

2003-08-09 Thread apples
>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: >Originator:

Re: Default character set error

2003-07-30 Thread Sergei Golubchik
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 &g

Default character set error

2003-07-30 Thread Kittiphum Worachat
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 for

re: Change default CHARACTER SET value

2003-02-12 Thread Egor Egorov
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 li

Change default CHARACTER SET value

2003-02-12 Thread Mirko
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

Re: default-character-set problem

2002-11-06 Thread Paul DuBois
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

default-character-set problem

2002-11-06 Thread nick gatsis
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

Re: How can I change my default character set without ./configure??

2002-04-19 Thread Egor Egorov
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.mys

How can I change my default character set without ./configure??

2002-04-19 Thread Gokce AKKAYA
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: http://www.mysql.com/

Re: problems with default-character-set=cp1251

2002-02-13 Thread Miguel Angel Solorzano
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

problems with default-character-set=cp1251

2002-02-13 Thread Victoria Reznichenko
éÌØÑ, 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 \\ s

problems with default-character-set=cp1251

2002-02-13 Thread Илья Евгеньевич Коробов
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 co

--default-character-set

2001-07-15 Thread pascal barbedor
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 of