TADOQuery insert special characters to the oracle database, the character:

Specific SQL statements:
INSERT INTO t_Sys_WordLookup (fChineseWord, fEnglishWord fBrazilWord, fRussiaWord) VALUES (N 'Bolt 22', N 'Bolt,' N '? Lzylinder ', N '? Lzylinder ');

On the oracle database SQL statements directly execute no problem, but through the TADOQuery execution, the last two fields first character into "?" ,

The same code, links sqlsever database there is no problem, insert the data correctly,

Under the great god give directions, whether TADOQuery link ORACLE has a bug,

CodePudding user response:

Feeling is the Oracle database character set issues, specific do not understand,

CodePudding user response:

Ccrun group was useful in Oracle, but don't know whether I use ADO component,

CodePudding user response:

INSERT INTO t_Sys_WordLookup (fChineseWord, fEnglishWord fBrazilWord, fRussiaWord) VALUES (" 22 "Bolt," Bolt ", "? Lzylinder ", "? Lzylinder ");

Have a try?

CodePudding user response:

INSERT INTO t_Sys_WordLookup (fChineseWord, fEnglishWord fBrazilWord, fRussiaWord) VALUES (" 22 "Bolt," Bolt ", "? Lzylinder ", "? Lzylinder ");
The more no, executed in ORACLE

CodePudding user response:

Reference

INSERT INTO t_Sys_WordLookup (fChineseWord fEnglishWord, fBrazilWord, fRussiaWord) VALUES (" 22 "Bolt," Bolt ", "? Lzylinder ", "? Lzylinder ");

Have a try?

The more no, executed in ORACLE

CodePudding user response:

Try dataexpress

CodePudding user response:

refer to the second floor ooolinux response:

ccrun group was useful in Oracle, but don't know whether I use ADO component,

Ccrun group is a qq group? Or WeChat group? Convenient said group no. Please, want to join the exchange,

CodePudding user response:

2602062 QQ group

CodePudding user response:

When I was doing the SQLITE, also encountered such a problem, the select field name with a special symbol, is also an error until I packed them with [] to
For example, the select field as [1] # pump current from aaa,
If directly in the SQL statements to write "the select field as 1 # pump current from aaa" would be an error, because the field name was not the Numbers, in the beginning,

CodePudding user response:

The last two fields first character into "?"
-- -- -- -- -- -- -- --
Where was you observed characters into "?" ? If it is in the form of interface control, the control of the default font does not support shows the characters? Try to change the font,

CodePudding user response:

The

references to the tenth floor ooolinux response:

the last two fields first character into "?"
-- -- -- -- -- -- -- --
Where was you observed characters into "?" ? If it is in the form of interface control, the control of the default font does not support shows the characters? Try to change the font,

Is not seen in the control, debugging to see

CodePudding user response:

Some functions are overloaded with TEncoding * parameter version, try TEncoding: : utf-8 parameters,

CodePudding user response:

refer to 12 floor ooolinux reply:

some functions are overloaded with TEncoding * parameter version, try TEncoding: : utf-8 parameters,

TEncoding: : UTF8

CodePudding user response:

Copied to a notepad, an ANSI question mark, a utf-8 is normal,