Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some characters are not indexed
On 2 Feb 2006 04:58:45 -0800, boguslaw.pazur_at_marcos-bis.com.pl wrote:
>SELECT * FROM vendor ORDER BY name
>
>cause result
>
>Name
>?AZ
>AZ
>BR
>?MARC
>MARC
>
>It seems like '?' is omitted. Maybe I'm wrong and it's question of
>sorting not indexing?
>
>TIA
>
>Boguslaw Pazur
It's a question of an incorrect characterset. The question marks refer to characters that can't be displayed on the screen properly. Either the NLS_LANG on your client is incorrect or the characterset of your database.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Feb 02 2006 - 13:06:14 CST