The original MS SQL table field type is CHAR, but can't display Chinese characters
MS SQL can be normal after changing NCHAR display Chinese characters, but the use of PB software while reading these fields: Select error: the data conversion overflows
Master, please have a solution?

CodePudding user response:

Field length is not enough, it is ok to increase the field length

CodePudding user response:

1. Normal conversion overflow is no relationship,
2. Nchar PB low version does not support, you can consider through the convert conversion, read or use selectblob way,
3. The data column to varchar try?

CodePudding user response:

I have been use varchar

CodePudding user response:

After the field type changed, need to update the data window

Simple way to open the Data window menu -- -- -- -- -- -- the Design, Data Source, and then cancel a certain field, select again on the field, so after operation, and will be using the latest tabular Data window