Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NVARCHAR2 for unicode database

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US