Dushy_Squirt Posted November 10, 2012 Share Posted November 10, 2012 Hi, I have imported a delimited text file into a MySQL database and one of the fields did not import correctly. In my import file I have a field formatted as text using text qualifiers that contains a mixture of fractional values and some integers but it is all formatted as text. When importing into MySQL the fractional part is being replaced by a question mark symbol, for example the value of 2¾ is imported as 2?. I have set the field value in MySQL as text but it still imports wrongly. Any advice most appreciated. Thx Dushy_Squirt Link to comment https://forums.phpfreaks.com/topic/270531-importing-text-field-with-fractional-values-2%C2%BE-into-mysql/ Share on other sites More sharing options...
Muddy_Funster Posted November 12, 2012 Share Posted November 12, 2012 you likely need to set the character encoding to utf-8/utf-16 for the table. Link to comment https://forums.phpfreaks.com/topic/270531-importing-text-field-with-fractional-values-2%C2%BE-into-mysql/#findComment-1391847 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.