On 05/25/2014 05:38 PM, Joseph wrote:
My php database, address book is set to (according to phpmyadmin):
Collation: utf8_general_ci
The collation determines e.g. how strings are sorted, but that doesn't
mean the database supports utf-8 (although MySQL should by default these
days).
Try
On 05/25/14 19:32, Michael Orlitzky wrote:
On 05/25/2014 05:38 PM, Joseph wrote:
My php database, address book is set to (according to phpmyadmin):
Collation: utf8_general_ci
The collation determines e.g. how strings are sorted, but that doesn't
mean the database supports utf-8 (although
On 05/25/2014 08:06 PM, Joseph wrote:
On 05/25/14 19:32, Michael Orlitzky wrote:
Then, in mysql, run,
show create database $your_database;
This will show you the default character set, like,
/*!40100 DEFAULT CHARACTER SET utf8 */
If it says utf8 and you've got those lines in my.cnf,
On 05/25/14 21:04, Michael Orlitzky wrote:
On 05/25/2014 08:06 PM, Joseph wrote:
On 05/25/14 19:32, Michael Orlitzky wrote:
Then, in mysql, run,
show create database $your_database;
This will show you the default character set, like,
/*!40100 DEFAULT CHARACTER SET utf8 */
If it says
On 05/25/2014 10:43 PM, Joseph wrote:
What about the output of show create database $your_database;?
Depending on how the database was created, it could still have another
character set.
I was trying to run this command in phpmyadmin:
show create database $temp;
I'm getting an error
On 05/25/14 23:00, Michael Orlitzky wrote:
On 05/25/2014 10:43 PM, Joseph wrote:
What about the output of show create database $your_database;?
Depending on how the database was created, it could still have another
character set.
I was trying to run this command in phpmyadmin:
show create
On 05/25/2014 11:36 PM, Joseph wrote:
Yes, it worked, and I get:
CREATE DATABASE `catalog_sys` /*!40100 DEFAULT CHARACTER SET utf8 */
so it looks OK I think.
Yeah, looks good. Here's what I'm using as a test case. Your columns
aren't regular 'char' types, are they?
mysql CREATE
7 matches
Mail list logo