MySQL Forums
Forum List  »  PHP

Re: Newby needs some help - collation/charset ?
Posted by: Rick James
Date: December 18, 2013 01:36PM

> `install_date` varchar(10) DEFAULT NULL,

(unrelated to charset problem) There is a DATE datatype -- this would let you do SQL comparisons between dates. See also DATETIME and TIMESTAMP.

> ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8'

OK, the columns are utf8.
(Unrelated to the charset issue: InnoDB is preferred over MyISAM.)

> There appears to be an error with the widgets.com database.

Alas, the 3rd party software seems to be hiding useful information from us. Complain to them.

> 'Erzeuge deine eigenen BBCodes und Buttons im ACP und speichere sie in der Datenbank'
> I'll look into the above shortly (as best I can :)

Find a row with an accented letter in the middle, preferably with a short text string.

Options: ReplyQuote


Subject
Written By
Posted
Re: Newby needs some help - collation/charset ?
December 18, 2013 01:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.