Re: Cant reproduce Problem in Lab
Posted by:
Rick James
Date: September 06, 2014 08:12PM
> I think that the application is maybe writing in a different way (with a different charset?) to the database than i do when manually inserting by shell.
Very likely. What language? Is there a SET NAMES? Or other setting of 'char%' variables? I feel that the application is at 'fault'.
> I tried to convert the whole Slave Database to UTF8, but ran in another Problem there. I get a "Index longer than 1000bytes" Error there.
Rarely is 255 really needed in "varchar(255)". Perform some SELECT MAX(length(colname)) FROM tbl to see how far from 255 the fields are. (You may be surprised to find some have hit 255 -- which may mean that they were truncated!)
Subject
Written By
Posted
September 05, 2014 05:52AM
Re: Cant reproduce Problem in Lab
September 06, 2014 08:12PM
September 06, 2014 08:14PM
September 15, 2014 08:58AM
September 16, 2014 11:17PM
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.