Can't insert ASCII value above 127 using utf8
Posted by: Tony Russo
Date: September 16, 2005 11:39AM


While importing data when any character value is above ord 127 MySQL will trunicate the field and give a warning

Using either PHP or SQLyog GUI when I excute either a 'INSERT' or 'LOAD DATA LOCAL INFILE' followed by a SHOW WARNINGS MySQL returns:

Warning 1265 Data truncated for column 'Remarks' at row 1

Edited 3 time(s). Last edit at 09/19/2005 08:51PM by Tony Russo.

Options: ReplyQuote

Written By
Can't insert ASCII value above 127 using utf8
September 16, 2005 11:39AM

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.