Hello, I am not able to change character set using "set character set".
/etc/my.cnf (important parts) [client] character-sets-dir = /usr/local/share/mysql/charsets ----------- content of that directory: dns:/usr/local/share/mysql/charsets# ls cp1251.conf dos.conf hp8.conf latin1.conf usa7.conf cp1257.conf estonia.conf hungarian.conf latin2.conf win1250.conf croat.conf german1.conf Index latin5.conf win1251.conf danish.conf greek.conf koi8_ru.conf README win1251ukr.conf dec8.conf hebrew.conf koi8_ukr.conf swe7.conf ------------- but when I enter mysql, I can't change it to any of those charsets. mysql> set character set "danish"; ERROR 1115: Unknown character set: 'danish' mysql> set character set "czech"; ERROR 1115: Unknown character set: 'czech' mysql> set character set "swe7"; ERROR 1115: Unknown character set: 'swe7' mysql> set character set "latin1"; ERROR 1115: Unknown character set: 'latin1' mysql> set character set "win1250"; ERROR 1115: Unknown character set: 'win1250' I have 4.0.20 (compiled by myself) Am I doing something wrong? Btw, when I specify default-character-set = czech in my.cnf, it works! But it works for whole server and that's exactly what I don't need. I need it just for any domains so their owners have to specify some "SET CHARACTER ..." after connection to db is made. Or is there any other workaround for solving this? Need to recode db to "czech" for several domains (db users...) Best regards and thanks for any advice. I am solving this for months :( Roman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
