I’m developer some oauth client application for iPhone

and i use the OAuthConsumer It’s has some trouble

and i fix it,

this is patch file.

http://my.unix-center.net/~WeiZhicheng/wp-content/OAuthConsumer.patch

pictures…

I’m using sqlalchemy 0.6 and mysql in my project,

but some times I got UnicodeDecodeError

and I check the sqlalchemy souce code and

I found why has this error,

It’s because when i insert a String(include Chinese UTF-8)

if the String byte not same with this field byte,maybe the

last one Chinese Char not insert complete.(BTW,Chinese is 3 bytes in UTF-8)

so if i query this field,utf-8 codec throw an error to me.

and write a patch to the sqlalchemy,It’s can fix this problem.

but It’s not perfect,this issue is the mysql not sqlalchemy.

so,if you write software like this,please careful process Chinese code and all non-ansi

code

patch download url:

http://my.unix-center.net/~WeiZhicheng/sqlalchemy.diff

for changeset:4721 in mericural repo

It’s My fault I don’t know the SQLAlchemy need set db connect charset

this is solution

engine = create_engine(’mysql://root:@localhost/dev?charset=utf8‘)

Sorry for All

这位小女孩叫怡帆，目前靠氧气机呼吸维持生命，要治愈小怡帆病，只能进行儿童肺移植手术。而这类手术在国内尚未有成功先例，而美国德克萨斯儿童医院 则经验丰富。潘俊廷和妻子周萍已经卖掉了房子，然而依然不够手术所需的50万美金（约合341万元人民币）的手术费用，对潘俊廷来说无异于天文数字。

潘俊廷是一位非常优秀的Linux程序员，他担任中国Linux论坛的版本，此网站会员捐赠42笔共42542.79元，目前来自各方的捐款合计达到了35万无，尽管如此，离手术费用还是相当的大，希望各位朋友一起帮助这位小女孩渡过难关。

帮助怡帆的官方网站，那里有详细的病情说明，并提供了捐款信息。

如果是默认django设置如果在url中加入中文参数
django是不能解析的.解决办法有两个