unicode troubles and postgres

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> (permalink)
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

Show key headers only | View raw

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~

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

unicode troubles and postgres Ethan Furman <ethan@stoneleaf.us> - 2014-01-09 10:49 -0800
  Re: unicode troubles and postgres wxjmfauth@gmail.com - 2014-01-10 02:44 -0800

csiph-web