MySQL Forums
Forum List  »  Install & Repo

need help in using utf8 charset
Posted by: mohsen ali momeni
Date: September 05, 2004 06:17AM

hello everyone ,

I use mysql-4.1.3 in Fedora(1 or 2) and I have problem running mysql with any collation other than latin1_swedish_ci.
I have read the manual and tested two cases;

what I did:
case 1)
./configure -prefix=usr/local/mysql
make
make install

then i installed db and ...

I start mysqld :
./mysqld_safe --user=mysql --default-characer-set=utf8 --default-collation=utf8_turkish_ci

./mysql
mysql>\s
it says : client-characterset=latin1_swedish_ci , server-characterset=latin1_swedish_ci

again I start mysql with command lines:
./mysql --default-characterset=utf8 (no --default-collation for mysql)
mysql>\s
it says : client-characterset=utf8_general_ci , server-characterset=utf8_general_ci
but still not utf8_turkish_ci

case 2)
./configure --prefix=user/local/mysql --with-charset=utf8 --with-collation=utf8_turkish_ci
make
make install

now mysql_install_db fails to create tables of database.There is no file containing error message in mysql/var folder.

I want to test utf8 characterset with any collation (not utf8_general_ci) but i don't know what the problem is.

Options: ReplyQuote


Subject
Written By
Posted
need help in using utf8 charset
September 05, 2004 06:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.