--0-1801859528-1083899202=:53939
Content-Type: text/plain; charset=big5
Content-Transfer-Encoding: 8bit


Dear Sir,
We use postgresql in our company. We found an error when restoring database. We guess the problem is due to the postgresql version.

Source Database:
- version: Postgresql 7.3.4
- encoding: EUC_TW
- OS: Red Hat 9

Target Database:
- version: Postgresql 7.4.2
- encoding: EUC_TW
- OS: Red Hat 9

Error message when I use the command - psql:

ERROR: invalid byte sequence for encoding "EUC_TW": 0xae61
CONTEXT: COPY items, line 2, column itemdesc: "Raaˆ]û?u¡¡Ó@¡¡Ó{ (?@) QEF01-0301"
ERROR: invalid byte sequence for encoding "EUC_TW": 0xab4f
CONTEXT: COPY old_directprog, line 1, column directprogdesc: "aÆÙY¢XIÆÙYo?O?jÆØI"
ERROR: invalid byte sequence for encoding "EUC_TW": 0xa745
CONTEXT: COPY receipt, line 72, column receivedfrom: "¡¡ÓE¡¡ÓR?A"

Would you please give us comment on how to solve this problem.
We are looking forward for your reply. Thank you very much!

Eric Tan
From Hong Kong


*ɹL¡B¤@©ç¨â´²¡B©_¬¥§õºû´µ¦^«H...
¥þ´ä³Ì¤j¤â¾÷¤U¸ü¤¤¤ß
http://mobile.yahoo.com.hk/

--0-1801859528-1083899202=:53939
Content-Type: text/html; charset=big5
Content-Transfer-Encoding: 8bit

<P>Dear Sir,<BR>&nbsp;&nbsp;&nbsp;&nbsp; We use postgresql in our company. We found an error when restoring database. We guess the problem is due to the postgresql version.</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp; Source Database:<BR>&nbsp;&nbsp;&nbsp;&nbsp; - version: Postgresql 7.3.4<BR>&nbsp;&nbsp;&nbsp;&nbsp; - encoding: EUC_TW<BR>&nbsp;&nbsp;&nbsp;&nbsp; - OS: Red Hat 9</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp; Target Database:<BR>&nbsp;&nbsp;&nbsp;&nbsp; - version: Postgresql 7.4.2<BR>&nbsp;&nbsp;&nbsp;&nbsp; - encoding: EUC_TW<BR>&nbsp;&nbsp;&nbsp;&nbsp; - OS: Red Hat 9</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp; Error message when I use the command - psql:</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp; ERROR:&nbsp; invalid byte sequence for encoding "EUC_TW": 0xae61<BR>CONTEXT:&nbsp; COPY items, line 2, column itemdesc: "Raaˆ]&ucirc;?u&iexcl;¡Ó@&iexcl;¡Ó{ (?@)&nbsp; QEF01-0301"<BR>ERROR:&nbsp; invalid byte sequence for encoding "EUC_TW": 0xab4f<BR>CONTEXT:&nbsp; COPY old_directprog, line 1, column directprogdesc: "aÆÙY&cent;XIÆÙYo?O?j&AElig;&Oslash;I"<BR>ERROR:&n bsp; invalid byte sequence for encoding "EUC_TW": 0xa745<BR>CONTEXT:&nbsp; COPY receipt, line 72, column receivedfrom: "&iexcl;¡ÓE&iexcl;¡ÓR?A"</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Would you please give us comment on how to solve this problem.<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; We are looking forward for your reply. Thank you very much!</P>
<P>Eric Tan<BR>From Hong Kong</P>
<DIV></DIV><p>*ɹL¡B¤@©ç¨â´²¡B©_¬¥§õºû´µ¦^«H...<br>
<b>¥þ´ä³Ì¤j¤â¾÷¤U¸ü¤¤¤ß</b><br>
<a href="http://us.rd.yahoo.com/evt=22281/*http://hk.yahoo.com/mail_tagline/?http://mobile.yahoo.com.hk/">http://mobile.yahoo.com.hk/</a><br>
--0-1801859528-1083899202=:53939--