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

Insert data in win1251 encoding to base with utf8 encoding

YuriyRusinov
P: 1
Hello !

I have database linkdb with UTF8 encoding. Script
Expand|Select|Wrap|Line Numbers
  1. \encoding WIN1251
  2.  
  3. begin;
  4.  
  5. \i ./database_schema.sql
  6.  
  7. commit;
  8.  
tries to set data with WIN1251 encoding and fails with error psql:./database_schema.sql:14: PANIC: ERRORDATA_STACK_SIZE exceeded. Data in database_schema.sql script are in WIN1251. Operational system Debian Linux 2.6.18-5-686, Postgresql server 8.1.9, locale
Expand|Select|Wrap|Line Numbers
  1. LANG=ru_RU.KOI8-R
  2. LC_CTYPE="ru_RU.KOI8-R"
  3. LC_NUMERIC=POSIX
  4. LC_TIME=POSIX
  5. LC_COLLATE="ru_RU.KOI8-R"
  6. LC_MONETARY="ru_RU.KOI8-R"
  7. LC_MESSAGES=POSIX
  8. LC_PAPER="ru_RU.KOI8-R"
  9. LC_NAME="ru_RU.KOI8-R"
  10. LC_ADDRESS="ru_RU.KOI8-R"
  11. LC_TELEPHONE="ru_RU.KOI8-R"
  12. LC_MEASUREMENT="ru_RU.KOI8-R"
  13. LC_IDENTIFICATION="ru_RU.KOI8-R"
  14. LC_ALL=
  15.  
What I have to do in order to set these data into database ?

Thanks in advance.
Yuriy Rusinov.
Sep 20 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.