Hello.
You set the character_set_xxx variables only for your session. MySQL CC is not under development now, and I don't know what it reads from MySQL configuration files. Usually putting the following string in the [client] section of the configuration file affects the clients to use specified encoding: default_character_set = your_encoding But only if client library is instructed to read options. MySQL CC seems to be not using this option. "John Berman" <[EMAIL PROTECTED]> wrote: > > Greg > > I use MySQL Control centre to access my dbase and I have set > > My character_set_xxx variables to Hebrew > > I then looked at the values, show variables like '%char%'; and all was fine. > > However if I then exit MySQL Control centre and then go back to it my > character_set_xxx variables are all back at their defaults ? > > I'm assuming this is a permissions type problem? > > > Regards > > John B > > -----Original Message----- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: 08 March 2005 21:06 > To: mysql@lists.mysql.com > Subject: Re: Hebrew > > Hello. > > In most encodings english letters remain unchanged, but to be sure > you may execute set NAMES latin1 before quering tables with English > data. > > > > > "John Berman" <[EMAIL PROTECTED]> wrote: >> Thanks will do this. >> >> In the same dBase there a lots of tables were the data is in English - I >> assume they will be ok ? >> >> John B >> >> -----Original Message----- >> From: Gleb Paharenko [mailto:[EMAIL PROTECTED] >> Sent: 07 March 2005 21:12 >> To: mysql@lists.mysql.com >> Subject: Re: Hebrew >> >> Hello. >> >> Put all your character_set_xxx variables to hebrew. See: >> >> http://dev.mysql.com/doc/mysql/en/charset-connection.html >> >> >> >> "John Berman" <[EMAIL PROTECTED]> wrote: >>> How's this >>> >>> >>> +--------------------------+-----------------------------------+ >>> | Variable_name | Value | >>> +--------------------------+-----------------------------------+ >>> | character_set_client | latin1 | >>> | character_set_connection | latin1 | >>> | character_set_database | hebrew | >>> | character_set_results | latin1 | >>> | character_set_server | latin1 | >>> | character_set_system | utf8 | >>> | character_sets_dir | /usr/mysql4/share/mysql/charsets/ | >>> +--------------------------+-----------------------------------+ >>> >>> >>> John B >>> >>> -----Original Message----- >>> From: Gleb Paharenko [mailto:[EMAIL PROTECTED] >>> Sent: 07 March 2005 12:28 >>> To: mysql@lists.mysql.com >>> Subject: Re: Hebrew >>> >>> Hello. >>> >>>> Pointers were I went wrong would be appreciated >>> >>> What's the default character set for your server? Please, send >>> us an output of the following statement: >>> >>> show variables like '%char%'; >>> >>> Please, use mysql command line client. >>> >>> >>> >>> "John Berman" <[EMAIL PROTECTED]> wrote: >>>> Using 4.1 >>>> >>>> Though I had it cracked ? >>>> >>>> I created a new table and set the Charset to Hebrew and the field = >>>> =A0Collation >>>> to hebrew_general_ci=A0 >>>> >>>> I then uploaded data to the database using MS Acess (with an ODBC >>>> connection) >>>> >>>> In MSAccess on my PC the Hebrew comes through fine. >>>> >>>> However when I open the newly created table using MSAccess or phpMyAdmin >>>> the Hebrew is represented with question marks. >>>> >>>> Pointers were I went wrong would be appreciated >>>> >>>> Regards >>>> >>>> John Berman >>>> >>>> --=20 >>>> No virus found in this outgoing message. >>>> Checked by AVG Anti-Virus. >>>> Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 04/03/2005 >>>> =20 >>>> >>>> >>> >>> >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
