Ask again adoquery insert Chinese save incomplete data

166609454

After I use adoquery to insert updated data, how do I always display only the first few in Chinese? A few are not displayed, and the English will not save errors. My database is sql server. What do you heroes have? A good solution is better.

xclzc17

It is a bug of DELPHI. Don't use ": variable" in SQL, construct SQL directly with string accumulation

Or use the data set to write the database.

I think you should write the database directly with SQL

tonnywoo

First of all, you have to make sure that the character set installed when SQL SERVER is installed is correct. Otherwise, SQL SERVER can only be reinstalled.
For this problem, I have concluded that DELPHI and SQL SERVER use different encoding methods. SQL SERVER uses UNICODE encoding, while DELPHI uses ANSI
the way. So when the Chinese character data is updated, it will make the Chinese character update incomplete. My method is to set the length to 100.
You can solve this problem.

166609454

I use parameters for zl1, is this not enough? Construct SQL directly with string accumulation, please give an example

I installed the SQL server directly for zl2. Is the installed data set correct? What should I pay attention to during installation, or should I increase the installation? You said that you added those codes to the BeforeExecute event of the stored procedure of the DATA MODULE of the application server ,
Can you make it clear, which control key is the BeforeExecute event on?

xclzc17

For example: adoquery.sql.text:='update table1 set field1=``'+Str1+''' where fieldkey=1';