vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I have been trying to find a reasonable GUI SQL client that displays results without rounding them. I was pointed to IBM's Data Studio, which we've FINALLY installed, but sadly it seems it also rounds. If I do this query from the command line: SELECT * FROM TARGET WHERE file_id = 8237 and accession_id = '200928_s_at' I get: FILE_ID ACCESSION_ID MEASURE ----------- ------------------------------ ------------------------ 8237 200928_s_at -2.78165375414833E+000 If I do the same exact thing in Data Studio I get: 8237 200929_s_at -2.782 I was also told this was JDBC, but there has to be a way to disable rounding, eh? Can anyone help? Thanks a lot, Alejandrina |