Re: NVARCHAR2 for unicode database

From: Leandro Guimarães Faria Corsetti Dutra <leandro_at_dutra.fastmail.fm>
Date: Mon, 22 Mar 2004 10:02:30 -0300
Message-ID: <pan.2004.03.22.13.02.28.702127@dutra.fastmail.fm>

Em Thu, 18 Mar 2004 20:22:29 -0800, wangbin escreveu:

> the following
> query doesn't use the index on clientusername. select * from client where
> clientusername = N'testuser';
>
> If I get rid of N, it starts to use the index. The datatype of
> CLIENTUSERNAME is VARCHAR2(32) .

Does your client environment uses Unicode all the way? If not, your string is not Unicode and needs not to be converted.

-- 
Leandro GuimarÃ£es Faria Corsetti Dutra           +55 (11) 5685 2219
Av Sgto Geraldo Santana, 1100 6/71               +55 (11) 5686 9607
04.674-000  SÃ£o Paulo, SP                                    BRASIL
http://br.geocities.com./lgcdutra/

Received on Mon Mar 22 2004 - 07:02:30 CST