Gentoo Archives: gentoo-user

From: Joseph <syscon780@×××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] php database character set
Date: Mon, 26 May 2014 03:36:08
Message-Id: 20140526033620.GF11936@syscon7
In Reply to: Re: [gentoo-user] php database character set by Michael Orlitzky
1 On 05/25/14 23:00, Michael Orlitzky wrote:
2 >On 05/25/2014 10:43 PM, Joseph wrote:
3 >>>
4 >>> What about the output of "show create database $your_database;"?
5 >>> Depending on how the database was created, it could still have another
6 >>> character set.
7 >>
8 >> I was trying to run this command in phpmyadmin:
9 >> show create database $temp;
10 >>
11 >> I'm getting an error message.
12 >>
13 >
14 >Oh, lose the dollar sign. It's common to prepend a dollar sign to a name
15 >to signify that it's a variable. It borrows from shell, perl, PHP, etc.
16 >which all do something similar for variables. It's ugly and redundant
17 >there, but email is actually one place where I think it makes sense.
18
19 Yes, it worked, and I get:
20 CREATE DATABASE `catalog_sys` /*!40100 DEFAULT CHARACTER SET utf8 */
21
22 so it looks OK I think.
23
24 --
25 Joseph

Replies

Subject Author
Re: [gentoo-user] php database character set Michael Orlitzky <mjo@g.o>