By default, MySQL uses ISO-8859-1 (Latin1) character sets. To change the default settings, use --with-charset selection: shell> ./configure - with-charset = charsetcharset can be BIG5, CP1251, CP1257, Czech, Danish, DEC8, DOS, EUC_KR, GB2312 GBK, German1, Hebrew, HP8, Hungarian, Koi8_ru, Koi8_ukr, Latin1, Latin2, SJIS, SWE7, TIS620, UJIS, USA7, WIN1251 or WIN1251UKR. See 9.1.1 The character set used for data and sort. Note: If you want to change the character set, you must make make distclean during configuration! If you want to transform characters between servers and customers, you should look at the Set Option Character Set command. See 7.25 Set Option Syntax. Warning: If you change the character set after creating any database table, you will have to run myisamchk -r -q for each table, otherwise your index may not be sorted correctly. (If you have Mysql installed, create some tables, then reconfigure MySQL to use a different character set and reinstall it, this will happen.)
