I have three records in varchar field. When I sort the records in asc order, the output is something like this: n, n1,n n,n But I expect the result would be: n, n,n n1,n Why? How can I solve the problem? Thanks.
Are you sure you got your ORDER BY clause correct?
Sure! You can try to input some sample data to test it. Any idea?
I did test it with the exact data you put in your post (I always do if I am not 100% sure), and it orders just fine.
What is your query exactly?
I execute the same statement in mysql, it works just fine but not postgresql. I had send u an email about my problem. Pls refer to it. Thanks.
