🚀 go-pugleaf

Try this:

 wchar_t* w = L"Insert into t (f1,f2) values ('\u4e01 ','AAA')";
 WideString wS = WideString(w);
 //Set this char again, it seems to be \x01 here.
 //Set breakpoint and see actual value. May be it will be correct for you.
 //Also \u014e seems to be chinese, instead of \u4e01.
 wS[32] = '\u014e';
 ADOCommand1->CommandText = wS;
 ADOCommand1->Execute();

And set ADOCommand1->ParamCheck = false, when parsing parameters VCL 
converts command text to AnsiString.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Bernd Muent" <kontakt@bmservices.de> ???????/???????? ? ???????? ?????????: 
news:427203b7@newsgroups.borland.com...
> Viatcheslav V. Vassiliev schrieb:
>> Which components do you use? Try use TADOCommand and CommandText - it is 
>> WideString. It seems that somewhere there is convertion AnsiString -> 
>> WideString.
>
> It tried it this way:
> ADOCommand* ac=new TADOCommand(this);
> WideString wS="Insert into test (f1,f2) values ('\u4e01 ','AAA')";
> ac->CommandText=wS;
> ac->Connection=dbConn;
> ac->Execute();
> delete ac;
>
> And this produces an entry "?"/"AAA" in the mdb-Database (viewing in 
> Access, not in CBuilder!).
>
> Greetings, Bernd