Every brother, my original is SQL2000 database, after changing SQL2005, when open the table data with PB10.5 found behind the char data type has a certain number of Spaces, I put the char type directly into a nvarchar space as well, don't know how to take Spaces in the data space to take out,
Suppose my char field is pass, set the length of 10, the inside of the data for the AAAAAA, now I want to call must be input six A plus four Spaces to verify through, too much trouble, if change the data, some of the data in the table there are tens of thousands of, can't manually change ah, do me A favor, thank you know the way
When I was originally opened by the PB6.5 SQL2000 no Spaces

CodePudding user response:

To varchar

CodePudding user response:

Guide to varchar, the data again


Or write a program that handles the Spaces, is mainly database type conversion problem

CodePudding user response:

The SQLCA. DBParm="* * * *, TrimSpaces=1"
Add this option to TrimSpaces=1