Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From: "Lew" <lew@THRWHITE.remove-dii-this>
Subject: Re: MySql with Hebrew.
Message-ID: <4dWdnWPXD_dfhIzVnZ2dnUVZ_ovinZ2d@comcast.com>
X-Comment-To: comp.lang.java.databases
Newsgroups: comp.lang.java.databases
In-Reply-To: <fuqqi0$9pc$1@news4.netvision.net.il>
References: <fuqqi0$9pc$1@news4.netvision.net.il>
Content-Type: text/plain; charset=IBM437
Content-Transfer-Encoding: 8bit
X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines: 24
Date: Wed, 27 Apr 2011 15:21:22 GMT
NNTP-Posting-Host: 96.60.20.240
X-Complaints-To: news@tds.net
X-Trace: newsreading01.news.tds.net 1303917682 96.60.20.240 (Wed, 27 Apr 2011 10:21:22 CDT)
NNTP-Posting-Date: Wed, 27 Apr 2011 10:21:22 CDT
Organization: TDS.net
Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:32

  To: comp.lang.java.databases
Mr. X. wrote:
> ...
> O.K.
> There is command :
> show create database mydb.
> results are (columns seperated by ",")
> mydb, CREATE DATABASE `cashereg` /*!40100 DEFAULT CHARACTER SET latin1 */
> 
> ...
> Well it is not utf-8 character-set.
> 
> How can I change the above setting ?

Have you considered reading the documentation?
<http://dev.mysql.com/doc/refman/5.1/en/alter-database.html>

-- 
Lew

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24