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] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.0 - Release Date: 08/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]