Jump to content

Importing Text Field With Fractional Values (2¾) Into Mysql ?


Dushy_Squirt

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.