Unsupported Screen Size: The viewport size is too small for the theme to render properly.

[Bug] Import Numeric Typing

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › [Bug] Import Numeric Typing

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 13, 2011 at 8:28 am #32415
      sathish
      Member

      Hello,

      This is an issue with the ODBC text driver. For csv there is no data type associated with the values so the driver has to perform a sampling on the data to identify the data type. This is 25 by default. so If you dont have any “double” value inside that 25 rows it will identify as integer or whatever apporiate. However you can modify this in ODBC configuration wizard in the source. So you have to change the sampling rate manually.

      Please follow the steps below to change the sampling rate:

      Start-> Run-> ODBC data source administrator-> User DSN-> Select the text driver->Click Configure->Options-> Define Format->Rows to scan- change the format to larger value(say 100)

      Please refer the screen shot for more information.

      Thanks,

      Sathish

    • July 13, 2011 at 11:22 pm #32416
      premixedpie
      Member

      Excellent that was what I was looking for. Thanks for letting me know this can be changed and sorry about the bad bug report!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.