dbTalk Databases Forums  

ordering text field with non-alphanumerical character

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss ordering text field with non-alphanumerical character in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hugo Coolens
 
Posts: n/a

Default ordering text field with non-alphanumerical character - 05-11-2005 , 12:06 AM






I want to order a text field which contains some words which begin with
a single quote, if however I perform the following query, the single
quote seems to be neglected:

select arabic, dutch from woordenlijst order by arabic;

After this query the words are ordered as if there _wasn't_ a single
quote in the beginning.
e.g. I get:
'arn eeuw
arrajul de man
'ashal gemakkelijker


How can I make a list of words with all text field values which start
with a single quote grouped together.
e.g.:
'arn
'ashal
arrajul

p.s.
you may wonder why I use words starting with a single quote, it is just a
standard approacht to transcribe the arabic character hamza that way



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.