Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder7.xlned.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <ethan@stoneleaf.us>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.002
X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'column': 0.07; 'error:': 0.07; 'from:addr:ethan': 0.09; 'from:addr:stoneleaf.us': 0.09; 'from:name:ethan furman': 0.09; 'means,': 0.09; 'message- id:@stoneleaf.us': 0.09; '~ethan~': 0.09; '32,': 0.16; 'context:': 0.16; 'exactly?': 0.16; 'fit,': 0.16; 'postgres,': 0.16; 'subject:unicode': 0.16; 'header:User-Agent:1': 0.23; 'bytes': 0.24; 'looks': 0.24; 'this:': 0.26; 'character': 0.29; "i'm": 0.30; 'test': 0.35; 'but': 0.35; 'should': 0.36; 'too': 0.37; 'system,': 0.38; 'to:addr:python-list': 0.38; 'sure': 0.39; 'to:addr:python.org': 0.39; 'received:173': 0.61; 'further': 0.61; 'revealed': 0.68; 'restore': 0.78
Date: Thu, 09 Jan 2014 10:49:27 -0800
From: Ethan Furman <ethan@stoneleaf.us>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121010 Thunderbird/16.0.1
MIME-Version: 1.0
To: Python <python-list@python.org>
Subject: unicode troubles and postgres
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-AntiAbuse: This header was added to track abuse, please include it with any abuse report
X-AntiAbuse: Primary Hostname - gator3304.hostgator.com
X-AntiAbuse: Original Domain - python.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - stoneleaf.us
X-BWhitelist: no
X-Source-IP: 173.12.184.233
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Source-Sender: ([173.12.184.233]) [173.12.184.233]:47820
X-Source-Auth: ethan+stoneleaf.us
X-Email-Count: 3
X-Source-Cap: dG9idWs7dG9idWs7Z2F0b3IzMzA0Lmhvc3RnYXRvci5jb20=
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.5279.1389296211.18130.python-list@python.org>
Lines: 12
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1389296212 news.xs4all.nl 2862 [2001:888:2000:d::a6]:49986
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:63626

So I'm working with postgres, and I get a datadump which I try to restore to my test system, and I get this:

ERROR:  value too long for type character varying(4)
CONTEXT:  COPY res_currency, line 32, column symbol: "руб"

"py6" sure looks like it should fit, but it don't.  Further investigation revealed that "py6" is made up of the bytes d1 
80 d1 83 d0 b1.

Any ideas on what that means, exactly?

--
~Ethan~