> Not sure that it makes a difference but the docs say psql looks at > LC_CTYPE not LANG for Unix systems. You did not say what OS you are > working on though from the examples I am guessing some form of Unix.
Thank you for the response. Sorry, I had not indicated OS information. OS information is the following: Red Hat Enterprise Linux Server release 6.2 Kernel 2.6.32-220.el6.x86_64 on an x86_64 The reason which was being verified using the LANG environment variable, I thought that the value of a LANG environment variable was set as LC_CTYPE when the LC_CTYPE environment variable and the LC_ALL environment variable are not set up. The LC_CTYPE environment variable was set up and re-verified. The result of psql command is following. [Result] % setenv LC_CTYPE ja_JP.eucJP % psql postgres -f test.txt -o result.txt EUC_JP % psql postgres -f test.txt > result.txt UTF8 % psql postgres -o result.txt < test.txt UTF8 % psql postgres < test.txt > result.txt UTF8 Even when a LC_CTYPE environment variable was set up, the result did not change. What do you think? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
