SQL_ASSISTANT "Error executing query for record 1: 22001: Character string truncated"

Tools & Utilities

SQL_ASSISTANT "Error executing query for record 1: 22001: Character string truncated"

hI,

   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! 

1 REPLY
Enthusiast

Re: SQL_ASSISTANT "Error executing query for record 1: 22001: Character string truncated"

HI

as error message indicates "Character string truncated" ...

your data is too large then the column length. Remove the junk characters from data file.

Regards

Kartheek