Re: hebrew in mysql

[Arik Kfir]

Whoops - forgot the SHOW CREATE DATABASE output, so here it is:

mysql> show create database homedvlp;
+----------+-------------------------------------------------------------------+
| Database | Create Database |
+----------+-------------------------------------------------------------------+
| homedvlp | CREATE DATABASE `homedvlp` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------------+
1 row in set (0.00 sec)



Here's the SHOW CREATE TABLE for the test case:

mysql> show create table users;
+-------+------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------------------------+
| users | CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(45) NOT NULL default '',
`password` varchar(45) NOT NULL default '',
`display_name` varchar(45) NOT NULL default '',
`version` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

10x again for any help!