469,138 Members | 1,422 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

Insert data in win1251 encoding to base with utf8 encoding

YuriyRusinov
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
0 2605

Post your reply

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

Similar topics

12 posts views Thread by Adam J. Schaff | last post: by
2 posts views Thread by Steve Long | last post: by
1 post views Thread by romiko2000 | last post: by
3 posts views Thread by tparks69 | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.