Dushy_Squirt Posted November 10, 2012 Share Posted November 10, 2012 (edited) 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 Edited November 10, 2012 by Dushy_Squirt Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.