Hello list,
I have already installed mysql 4.1.3 beta to my
windows xp. I set default-caharacter-set to latin5 and
default-collation to latin5_turkish_ci in my.ini
configuration file. Because I want latin5 my default
character set. Then I restarted mysql service and
looked up character set and collation variables. And
get cofused.
- In WinMySQLAdmin1.4 variables tab I see the
following results:
character_set_client = latin1
character_set_connection = latin1
character_set_database = latin5
character_set_results = latin1
character_set_server = latin5
character_set_system = utf8
collation_connection = latin1_swedish_ci
collation_database = latin5_turkish_ci
collation_server = latin5_turkish_ci
- When i execute "show variables like '%character%'"
and "show variables like '%collation%'" queries from
the command line i get the same results.
- When i execute the same queries from phpMyAdmin
2.5.7-pl1 i get different result set.
character set client = latin5
character set connection = latin5
character set database = latin5
character set results = latin5
character set server = latin5
character set system = utf8
collation connection = latin5_turkish_ci
collation database = latin5_turkish_ci
collation server = latin5_turkish_ci
First off all I could not understand why the results
are different. And second, does not all my variables
have to be latin5 and latin5_turkish_ci because of the
configuration I have done in my.ini file?
Thanks in advace.
Harun
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
