| Subject | Re: [firebird-python] Re: Can't search DB with accents |
|---|---|
| Author | starglider develop |
| Post date | 2010-09-02T19:38:31Z |
Hi Philippe,
the databse defenition are:
SET SQL DIALECT 3;
SET NAMES NONE;
CREATE DATABASE '192.168.0.102:/data/db/livros.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET NONE;
CREATE TABLE LANGUAGES (
LG_ID INTEGER NOT NULL,
LG_SHORT VARCHAR(5),
LG_LONG VARCHAR(30)
);
ALTER TABLE LANGUAGES ADD CONSTRAINT PK_LANGUAGES PRIMARY KEY (LG_ID);
I execute a query from a self made procedure:
sql = 'select * from item_log where item_log.il_title containing \'Solidão\''
dataset = dbmain.OutputQuery(param.db_host, param.db_file, sql, False)
this doesn't give any result.
This giive the espected result:
sql = 'select * from item_log where item_log.il_title containing \'Solid\''
dataset = dbmain.OutputQuery(param.db_host, param.db_file, sql, False)
thank you for your help.
the databse defenition are:
SET SQL DIALECT 3;
SET NAMES NONE;
CREATE DATABASE '192.168.0.102:/data/db/livros.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET NONE;
CREATE TABLE LANGUAGES (
LG_ID INTEGER NOT NULL,
LG_SHORT VARCHAR(5),
LG_LONG VARCHAR(30)
);
ALTER TABLE LANGUAGES ADD CONSTRAINT PK_LANGUAGES PRIMARY KEY (LG_ID);
I execute a query from a self made procedure:
sql = 'select * from item_log where item_log.il_title containing \'Solidão\''
dataset = dbmain.OutputQuery(param.db_host, param.db_file, sql, False)
this doesn't give any result.
This giive the espected result:
sql = 'select * from item_log where item_log.il_title containing \'Solid\''
dataset = dbmain.OutputQuery(param.db_host, param.db_file, sql, False)
thank you for your help.
On 2 September 2010 17:46, Philippe Makowski <makowski@...> wrote:
>> Hi,give us a small test case
>> I'm developing a new application to store book data,
>> my problem is when I do a search with accents like "Solidão" it gives no
>> results.
>> Searching a word without accents works great.
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-python/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-python/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-python-digest@yahoogroups.com
firebird-python-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-python-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/