ClientDataSet's Filter Cannot Deal w/Chinese

Article View: borland.public.delphi.database

Article #136

Back to borland.public.delphi.database Previous Next

#136

From: Lo Yuk Fai
Date: Thu, 29 Jan 2004 21:13

19 lines
1249 bytes

A filter like this was setup:

[FIELD] LIKE '%[STRING]%'

When [FIELD] is a "ftString" field in Delphi and "varchar" in
Firebird, and;
     [STRING] are some Chinese character(s).

The filter will not work.

If [STRING] are some English character(s), the filter will work as
expected.

Test done on a Windows XP box with Traditional Chinese(Chinese
(Taiwan)) set as the locale.

Any idea?

Thanks in advance.

Technical Details

Message-ID: <ad6657f9.0401291313.439f0f12@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,1b06d5fd76ced846,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2004-01-29 13:13:35 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: loyukfai@hotmail.com (Lo Yuk Fai)
Newsgroups: borland.public.delphi.database
Subject: ClientDataSet's Filter Cannot Deal w/Chinese
Date: 29 Jan 2004 13:13:35 -0800
Organization: http://groups.google.com
Lines: 19
Message-ID: <ad6657f9.0401291313.439f0f12@posting.google.com>
NNTP-Posting-Host: 202.60.249.81
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1075410815 1116 127.0.0.1 (29 Jan 2004 21:13:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 29 Jan 2004 21:13:35 +0000 (UTC)