How to display full column length in SQL
-
Hiya I have an MFC app that writes data to my SQL database. The columns lenghts are set to 30. But when I open my SQL database to view the contents, I can only see the first 15 chars of each column.. How do I get the SQL database to display the full columns lenghts when it is opened?? Thanks, grahamoj.
-
Hiya I have an MFC app that writes data to my SQL database. The columns lenghts are set to 30. But when I open my SQL database to view the contents, I can only see the first 15 chars of each column.. How do I get the SQL database to display the full columns lenghts when it is opened?? Thanks, grahamoj.
Are you passing spaces at the end of the values at all, is it 30 characters of data, could you be trimming the values? -Nick Parker
-
Hiya I have an MFC app that writes data to my SQL database. The columns lenghts are set to 30. But when I open my SQL database to view the contents, I can only see the first 15 chars of each column.. How do I get the SQL database to display the full columns lenghts when it is opened?? Thanks, grahamoj.
in query analyser, tools menu, options, results tab, maximum output characters per column. jon
#include <beer.h>
-
in query analyser, tools menu, options, results tab, maximum output characters per column. jon
#include <beer.h>
Hiya thanks, have checked that but it is already set to 256 chars. What I do is write the info to the database and then using Enterprise Manager, go in to the table to view it. All of the string is in the column. I can see it when I expand the column. What I want to be able to do is when I open the table in Enterprise Manager, I want the column already expanded to the full lenght of the string... Any ideas, grahamoj