Yuren's Info Area
yurinfore
Yuren's Info Area is about »
tag cloud
- about:config
- adobe
- apt
- apt-get
- artwork
- asus
- beagle
- beryl
- compiz
- compiz fusion
- coscup
- deb
- debian
- deborphan
- desktop
- downthemall
- drbl
- editor
- eee-pc
- eog
- evolution
- fedora
- firefox
- firegestures
- flash
- font
- foxconn
- geany
- gmail
- gnome
- gnome-panel
- google calendar
- google desktop
- google docs
- google maps
- google presentations
- google profile
- google reader
- google talk
- graphviz
- gtk
- gtkorphan
- hardy
- icos
- intel
- irc
- irssi
- jaiku
- jamei
- java
- jserv
- kalug
- kkbox
- laptop
- lazybuntu
- lazyeeepc
- libgtkembedmoz
- linux
- linux taiwan
- lively
- logo
- mac os
- mint
- moblin
- ms windows
- music player
- mx510
- opcion
- open source
- openca
- openoffice.org
- openstreetmap
- palm
- picasa
- pidgin
- postgresql
- python
- qt
- remember the milk
- remix
- rpm
- rtm
- ruby
- ruby on rails
- screenshot
- software
- sources.list
- ssh
- sshfs
- symbian
- tab
- tero
- thinkpad
- todo
- topic
- tosres
- trackpoint
- translation
- tunnel
- ubuntu
- ubuntu 8.04
- video
- vim
- virtualbox
- vpn
- wlot
- x-window
- xandros
- zenity
- 中文
- 富士康
- 硬體
- 高雄
» postgresql 備份/還原問題
今天在把 postgresql 7 的資料庫移到 postgresql 8 的時候出現詭異的問題：
value too long for type character varying這個問題詭異的地方是我之前已經拿一台機器測過，上面跑的也是 postgresql 8，沒出問題，換台機器就有問題，明明都一樣用 debian etch。如果有這種問題的，指定編碼就可以順利通過了，不過會遇到這種問題還蠻奇怪的。
createdb -E UNICODE ncyugamedb
