By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,773 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,773 IT Pros & Developers. It's quick & easy.

why ORDER BY works wrong in pg7.3.4?

P: n/a
Hi,

Help me pls a little with locals in postgres 7.3.4

why "order by" and "like" doesnt work in 7.3.4 properly? - im working
with ALT server local settings.

in 7.2.xx all this things worked well .

Thank u . and have a nice day!

Igor.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
igor <ro**@osb368.nnov.ru> writes:
why "order by" and "like" doesnt work in 7.3.4 properly? - im working
with ALT server local settings.
in 7.2.xx all this things worked well .


Most likely you forgot to select the right locale settings before
initdb'ing the 7.3 installation. pg_controldata can help you check
what locale is in force in the database.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #2

P: n/a
Thank u for hint it really helped me - I made initdb with new lc-ctype
and lc-collate
settings : ru_RU:UTF8.
But im still having one question - some functions - lower() and upper()
doesnt work properly . what im doing wrong?
Tom Lane wrote:
igor <ro**@osb368.nnov.ru> writes:

why "order by" and "like" doesnt work in 7.3.4 properly? - im working
with ALT server local settings.
in 7.2.xx all this things worked well .

Most likely you forgot to select the right locale settings before
initdb'ing the 7.3 installation. pg_controldata can help you check
what locale is in force in the database.

regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #3

P: n/a
igor <ro**@osb368.nnov.ru> writes:
Thank u for hint it really helped me - I made initdb with new lc-ctype
and lc-collate
settings : ru_RU:UTF8.
But im still having one question - some functions - lower() and upper()
doesnt work properly . what im doing wrong?


We don't have any support for upper() and lower() in multibyte character
encodings, such as UTF8. You need to use a single-byte encoding (and a
locale setting to match, of course).

Yeah, I know this sucks :-(. I think Peter Eisentraut is looking into
fixing it for 7.5.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #4

P: n/a
Thank u for hint it really helped me - I made initdb with new lc-ctype
and lc-collate
settings : ru_RU:UTF8.
But im having one question - some functions - lower() and upper()
doesnt work properly . what im doing wrong?
Tom Lane wrote:
igor <ro**@osb368.nnov.ru> writes:

why "order by" and "like" doesnt work in 7.3.4 properly? - im working
with ALT server local settings.
in 7.2.xx all this things worked well .


Most likely you forgot to select the right locale settings before
initdb'ing the 7.3 installation. pg_controldata can help you check
what locale is in force in the database.

regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.