Re: Database migration failing.
Posted by: Rick James
Date: June 07, 2011 08:27PM

Do
SHOW CREATE VIEW viewname \G
You will see something like this:
*************************** 1. row ***************************
View: hostls
Create View: CREATE ALGORITHM=UNDEFINED DEFINER=...
character_set_client: latin1
collation_connection: latin1_swedish_ci

Note that there is a charset associated with the VIEW. In your case, it is probably the wrong charset.

Recommend you drop and recreate the view with the appropriate charset and collation.

Probably this is the way:
SET NAMES 'utf8' COLLATION 'utf8_general_ci';
CREATE VIEW ...;

Options: ReplyQuote


Subject
Views
Written By
Posted
4661
June 02, 2011 04:28AM
1603
June 06, 2011 10:06PM
1718
June 07, 2011 02:49PM
Re: Database migration failing.
1723
June 07, 2011 08:27PM
2536
June 08, 2011 10:44AM
1675
June 08, 2011 09:00PM
1584
June 09, 2011 09:59AM


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.