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
4768
June 02, 2011 04:28AM
1641
June 06, 2011 10:06PM
1760
June 07, 2011 02:49PM
Re: Database migration failing.
1765
June 07, 2011 08:27PM
2579
June 08, 2011 10:44AM
1703
June 08, 2011 09:00PM
1616
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.