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]