The screenshots below is CXGRID from SQL SERVER 2000 found out as a result, my mouse click "cookies" back after the cell shows a lot of Spaces, and click the other cells are also behind the text plus these Spaces, I don't have the mouse to choose, click the cell will be displayed that, on my database didn't play space, show up why this happen? Amount is numeric types don't show that, whether for SQL SERVER shows the string length caused by? Database field type is string type, I am not use ACCESS database, whether by setting the CXGRID or SQL SERVER to solve this problem, looks very uncomfortable ah, trouble master teach me method,

CodePudding user response:

Do you use a char or nchar types in the database will be "goods" should be change the data type of the field to varchr or nvarchar, then execute the script in the database:
The update table name
The set of goods=rtrim (goods)

CodePudding user response:

One of the database driver TrimChar properties, hooked on it, to the head and tail of the client's string will automatically intercept space, no longer appear you,

You use TSQLConection connection control, for example, when you specify an option for Driver attributes (MSSQL, for example), then click enter the Drvier, have TrimChar attribute can be set up,

CodePudding user response:

reference 1st floor Oraclers response:

do you use char or nchar types, "goods" in the database should be change the data type of the field to varchr or nvarchar

Yes,