MYSQL_FIELD::charsetnr says latin1 when it should say utf8
Posted by: Angus M
Date: December 10, 2008 11:04AM

I have this table who's CREATE TABLE is as follows:
CREATE TABLE `HTML_CONTROLS` (
`PDFID` int(10) unsigned NOT NULL,
`Name` varchar(50) NOT NULL,
`Valyou` text NOT NULL,
`DateCreated` datetime NOT NULL,
PRIMARY KEY (`PDFID`,`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

However, when I do a query on the table and get the charsetnr for Name and Valyou they come in as 8 which is latin1. Shouldn't they be utf8?

The server is 5.0.

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL_FIELD::charsetnr says latin1 when it should say utf8
745
December 10, 2008 11:04AM


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.