Article View: borland.public.cppbuilder.database.ado
Article #1432ADODataset, Unicode, Retrieve LIKE records
From: Al
Date: Wed, 21 Jul 2004 18:01
Date: Wed, 21 Jul 2004 18:01
28 lines
1939 bytes
1939 bytes
I am not certain if this is an ADO problem, or some other issue, I hope I am posting in the correct group. If I am not, please let me know. I am connected to an MS Access 2002 Database which has Japanese characters in it. I can see the Japanese characters in the database and on my form when I do not discriminate the search criteria (SELECT * FROM altname). However, when I do discriminate (SELECT * FROM altname WHERE altname LIKE '%JAPANESE CHARACTER%'; I do not receieve anything in my results. I have tried the same SQL in ACCESS and it returns the correct data. Code snippet: ADODataSetSearch->Active = false; WideString sql; sql = "SELECT type, taskname, alttype, alttaskname FROM search "; sql += "WHERE taskname LIKE '%"; sql += edtMatch->Text; sql += "%' OR alttaskname LIKE '%"; sql += edtMatch->Text; sql += "%'"; ADODataSetSearch->CommandText = sql; ADODataSetSearch->Active = true; If I type English into edtMatch field, I get good results, if I type Japanese, I get nothing, even if the data is exactly cut/paste from database. btw, edtMatch is Unicode enabled (it's a TnTEdit COntrol). Any ideas?
Technical Details
Message-ID:
<f5725fd.0407210914.937a92e@posting.google.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!postnews2.google.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,61e315412738275f,start X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews2.google.com!not-for-mail From: allan.d.bailey@boeing.com (Al) Newsgroups: borland.public.cppbuilder.database.ado Subject: ADODataset, Unicode, Retrieve LIKE records Date: 21 Jul 2004 11:01:16 -0700 Organization: http://groups.google.com Lines: 28 Message-ID: <f5725fd.0407210914.937a92e@posting.google.com> NNTP-Posting-Host: 130.76.64.14 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1090432882 17160 127.0.0.1 (21 Jul 2004 18:01:22 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 21 Jul 2004 18:01:22 +0000 (UTC)