I encounter a error when i use SQL Assistant 14.0 to load a.txt to database,the error imformation is:"Error executing query for record 1: 22001: Character string truncated"
the content of a.txt is
"aaaa" : "中国"
"bbbb" : "英国"
my os's code page is (ansi 936)/(gb2312)
can any one solve this error,thank you in advance!
as error message indicates "Character string truncated" ...
your data is too large then the column length. Remove the junk characters from data file.