| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
 [SA 6.4.208 preview] Float columns not visible in Notepad++ |
 |
The contents of float type columns are not visible in Code Execution Output when executing code from Notepad++.
|
|
| Thu Jun 06, 2013 8:50 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
That's weird. What about decimal columns? Which connection method (ODBC, ADO, etc) do you use with Notepad++
|
|
| Thu Jun 06, 2013 11:06 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Weird, indeed. Decimals are fine. Perhaps it's related to libmysql.dll. Everything is okay when using ODBC connections.
|
|
| Thu Jun 06, 2013 12:08 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I'm not quite sure if the conversion from a binary float value to a display string takes place in the libmysql or in our code after the value is already retrieved. I know in fact that we have implemented separate database interfaces for different types of drivers.
I'm going to log a case and ask our developers to investigate this issue.
|
|
| Thu Jun 06, 2013 5:19 pm |
|
|
Mindflux
Joined: 25 May 2013
Posts: 846
Country: United States |
|
| |
|
Tested in NP++ with SQL Server 2008 SP3. I can see floats ok. I know you are using MySQL here but I wanted to chime in on it.
|
|
| Fri Jun 07, 2013 10:56 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Thanks. It seems to be affecting different types of MySQL connections.
|
|
| Mon Jun 10, 2013 2:59 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
It appears the issue is specific to libMySQL.dll versions 5.5.2x released relatively recently. Any older version of MySQL client should be fine. MySQL ODBC drivers seem to be fine too. I recommend copying an older version of libMySQL.dll to your computer and pointing SQL Assistant to the that version in the connection options (click the Options button on the Connect to Database dialog and in MySQL DLL parameter enter path to an older version).
Last edited by SysOp on Mon Jun 24, 2013 8:02 am; edited 1 time in total |
|
| Fri Jun 21, 2013 7:18 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Good to know. Thanks for the feedback.
|
|
| Fri Jun 21, 2013 11:08 am |
|
|
|
