Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e8B7DWf29414 for ; Mon, 11 Sep 2000 03:13:33 -0400 (EDT) Received: from sranhk.sra.co.jp (sranhk [133.137.36.134]) by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id QAA04616; Mon, 11 Sep 2000 16:13:30 +0900 (JST) Received: from localhost (IDENT:t-ishii@localhost [127.0.0.1]) by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id QAA19021; Mon, 11 Sep 2000 16:13:30 +0900 To: petermount@maidstone.gov.uk Cc: zeljko@technologist.com, pgsql-interfaces@postgresql.org, peter@retep.org.uk Subject: RE: JDBC and Unicode problem In-Reply-To: Your message of "Mon, 11 Sep 2000 07:53:52 +0100" <1B3D5E532D18D311861A00600865478CF1B393@exchange1.nt.maidstone.gov.uk> References: <1B3D5E532D18D311861A00600865478CF1B393@exchange1.nt.maidstone.gov.uk> X-Mailer: Mew version 1.93 on Emacs 19.34 / Mule 2.3 (SUETSUMUHANA) Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20000911161329T.t-ishii@sra.co.jp> Date: Mon, 11 Sep 2000 16:13:29 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 980905(IM100) Lines: 131 X-Archive-Number: 200009/35 MOTOKI Sinichi, a subscriver of our PostgreSQL local mailing list, has made a patch for 7.0.2 JDBC driver. With the patch and MB enabled installation (configure --enable-multibyte=UNICODE), you could use UTF-8 acording to him. You will need to create db with -E UNICODE if you did just --enable-multibyte (witout =UNICODE), or you choose other encodings. -- Tatsuo Ishii > I was thinking of parameter's to the JVM on startup (like > -Djdbc.driver=org.postgresql.Driver ) > > As for connection properties, yes they are an ideal place, and back in the > 6.3 days we used to use them so the mechanism is in there. I think the > connection properties is the way to go, as it would then work everywhere. > > Peter begin 644 postgresql-jdbc-7.0.2-ce.diff.gz M'XL("*5KI3D"`W!OMFGJ__W;>TDG M(0GP(X\VC,<&W=[>WC[N=O?V\#=H/+-\!#\&6AB!.4-3UT,+UP\N/>R_MZM_ M3B[,:D>MJSH*7!0N)D:`D160#YE051/O?(/@9^PB8[&PER@@`U#N_(W&=!L.C7:M?7U^H"0%33G=<&9XQO7K]2T-[-'O)G;FA/T`5&.@()SJS+&?88 M!S(D01GGA@'%%/J8S%SFRE:2XARFK#70!)O8"=!S`'1P-5@NH-,,VW8_0Z:T M01)B6GRQ\)P]+CL_!.H-UE.AC7-CB1R,)X1$X%MHV#!5T\.@J%1JF*+U"5Y@ MTK4#/++=ZTC%&I**Y6I7AEZ-9QCX9GB8=@51PM@3GU+":&$DU";8Q@&GH2;X M9F$?^+$3N&0V>ZYW68N-J:::5[YUZ;@>WMLQ9W-W@NKM9K,0+!M1&%AV;3`S MO('K7&$O`(7XT[@R"K'F]BD8X@A/C=`.[C)20=>"`4]"V[[+:'G]F#Q!SER, M")KFE@/B\R4])0U4TK]=W MJM6J#/>C9S&X%JHW^HU.O]%D<$^3+XI?TUJ*IFN(/D"H5/I/^>S%\\/1<85) MY.Q%X+[#CO47R,*T#=]'_\L$&_WZZOC&Q(O`B+'W6M::B:SVFST2&NM91=#`%+L-U$NP7R9@L1JLX4E+KYTLU MNW]*H/U\@=/^^VB]K/O%^I"-)U\5^AMI33;6'(7IKU(K1^O=NOM_.WB'IL3!HSHWUT1`UW0+C( MY+1F9TR1`D)V@,ED.:0;_.8<3/?,96,*4-Y;-93-V527=1ONFMXRC_6^UNSK M!=MP4U.:[9C/Y&-7+%D(_%WKBH1UH\"SG$OJ\9Z'GGV0U6B&G@_QQ3-$-/.@ M5*L1C2>AH$5(`V>(AX@N*9K(T#J`U6^P.6'BX7K$9?M@D=#'$)$ M?FS#4,F@2SKF!'P>,BO+B7!X9LUR3#NUQ;OB=NHSC(YWVDHG9YP M?^(IH;/A$=@_B25-\"T-PCST#@:]QN@2!W%D>0'Q)X9U`N9D8M_G2!;AA6V9 M0!5,UIH+=>IC3_3Q)YDEW:ZN=#NQ776;BE;OR$RXY7\E M\O8%>2.8O@EV8)A$\[%CNA-J8<(88L@?%@:)1V,S29D/=9'V(TKW929=N=8$ M^3BYF99S[*_"^WZ`OR5B(*ILFM'[`PYV2^QT?W5F+\C,N#%N.$,/!Z'G;-D`4S6HT@0+PP?&8;P(A)3HBE*9K6D=>8LQ?G9Z>OQR`RLMP= MQ$]_.AV1IV0E9>MYF8Q9D2!&X\/QFQ'`#$Y/3HX'X^'IR?GSPZ/T6E)#)^XU M(ADJ2JGEP/)OV!(?.&#@+<5\@?%TCV\`N8V>;"2/0RZGN%CU5\/1Z=YN1V)H7+,N[ MHC'"`OVL:3GNP\A"?_\=X5'Q>[!7O[R[6ZF(HI?8Q^B#;(5+PS#\R(6'`B35'>E;;:,,:8%&],0/1A<7GN!R2EIJ[,/][% M)#M^"'O(,NJ&UE`:C5:4V.(60/_^:&%[\L=;,!?XZTN&0EM_H^$?"D(2[?'5 MC3TKQTIUL0PP8+@(IQR"/B#,LK%S&/;MP71N#VS6; M$I6>@O;@J(V;&82A5\!+(P@%B0J:^Y<4K$1P,D_^W'1#^/`,:3$"65?`/S;L M<^QY<500\:/*"9RBLDPZ^AYUM9Y>(>VE310$)*L&,",7%$.!!Y5H"+;ZEDH? MZ.^D@HQ@QR0:4M[[=0]Z5#D`XRE!"W;Y'-C*A9W5O0S`N8T4=SVS>6J'_HR+ MLW3+#`>5AZI1/?#2=_`)4;T4_ M]A/BC]8*U:>9RS+3-%$/Z+$T)(DC!;YH?R.^OU M?J/7UUOYZ2$='%0IC"4?L])#+@3;@>0!)Q-$0W(VRD@@&D>/2I,0S\/I%'MX M!/EXRKU5/T=DM2IZ>U'2F+P;?(U]C$ MUA7F<0/9$^?A;A:V-?F(GW$'2!#F"*Z$7?-N&R$UV)1FVMP*(#."+;3S7 MZ=7;35@H&I+32]=;ZM^A[Y\)$EG3)FLXWY9@7YR'YBSA]!*:BN(%_JP]7F*J'P+%(&"?<:DM?U"$PANR8AD2+G*&24WP\Z-JDA[*W*'T3)B3L?LK#LE*FT^QN5@JE:%I#E$/Q2PCI M$@4RY@&+A<&I(1X2/=*R7+5(SKP'/[`751+"*2+Q+BN`I/<=Z#D)KX*6$BFK MQ_,45XVAYI$L0Y/@"31^R"H8X#5$=&(#@5M03IRW0`+(&3U9$I"L6LK''1<< M):J4W(!Y?ODE!*):0.J6F!(_W(\.]HY()1$MDA+'^YO,!_T0^;NH2*AQ!_DU M9`.1FH))3`GWA2-D&V.B2 M:QLB\4>*^DCP*;#[*PC#C(<*?<^XH[Z\37C'R6M>X@B?P`NF;K"QE"W$PT7R,/)AIHJI>2SD`]G?_ZI M,Q<@`[B'@!B"1(W#Q]E4T^`8^-3&'CQR\9K$1X9N`'@QO'-E.&!8Q M\5^,A0AIUU+%D-"B<-CU7@(WLTKC:3LW;!20VXPH[LQO0ZI=5",7?U%NK,RM MD%95<3\"=JH,XI_%A^GPV@7JSP]'@^%P5T&[H5\U?-.R=A49Y/C-X/SE&6D7 M[]*M@Q/12MZE6W]^+5K)NW3K^'?12M[)K6].AH/3HV-*6#"M=I.MO[QY=7P^ M/!D?OSXY?`4PM!!-!GAU.!Z>:*2WY;O5;K?5JVJ[JQ!Z`D+/@&@D(!H9$,T$ M1#,#HI6`()]DD)]/AUT"\,ZUNE6/=B_M_CZD7!V<:7I+X\\.7XW9LVZ[O2L6 MRX.DM0$'6YMJ;P9M!?I*0/J*9?%?5S4=2/LJ*>MS^%NK:YNG;OKZ[M^ZEK@4OP55T_ MM;KB+?U6H9R2PFVLI6L.S0,Y""[+-/!S\WXW8JRZ,_OOU78`*6X1;5( MP'TZ+>]J:F.W0I(K]4IT.Z.(Y!+-JJ!L5/H]48FK>70=)??S[H^FLXHF:\5= MCZC]4(A:&R'2UB-J/A2BQD,ATA\*D?9`B#9!$QD0R7*5Z"]^BQ.;H6<%RU11 M!P?B![`2LC*,P,RQ\"QR974YV/P`G,QA=:V-%C]H+CA_%L>D,LGR,I5(#"9W MACDSM6W.-C;>H1B,CE[[=KYB'WX+#5^T0ZS MNG7@.2M23_!%[!M3UZ,W&2QZT0#^?`?P_'R(?-Q_AO2*M"?@^1_66V$;*^,S M,Q%\!E"TC[2W8JQ$T=5'87S@A;A&KSL6\%IA-?+N?^TR"COCB5'Z?`^%EX6B\:/(S"T]N'*%GY6A=QW[J(.^M)NI+BCII06)!Q_Z/JO.\V+CRGSOE6S/Q#ZNP. M=SFASL%T]WKIEO;O.9UF"5F&;(61VQU0?]T0'W(9DS/EVVZ+I:\5DU^(R.XA MD!6)?'4`9#%\-N61M\DO\8^_L%_Z&O]#\@\S\K[+_QMT1)Z)O#9_]9&FUED; M^?Y3!WL&$1UO2]5F=?MZAVU^WZ`7$>S%,D86_8L0I*L4[#5)`/KQMTQ;L)#V MT7^Q#VT+M!?_!P%-TSMUU&MWM*:NMYJHKM7)_TT`,+/H/TT@UJ?1T+MMJ<]B MI<_*5S#KC6ZGQSIW]':SL'/ZVWAZS:Y.NVH=K=TJ[)IQ4;_9[;5Y;UW3"GMG MWZS6FPV]+L9O===B6+THVFCWNKT(0Z^0VWFWW03K.WJWNQY!?N4BBL3>UM;C MR7$KLXF1+"9M&Y+9)&SJG16@/]B_2IGD&\!;;E.D^V"&S7=^..^C+KA\>KO3 1ZZ)V&P1+0?X/KKV`VM%H```` ` end