RE: JDBC and Unicode problem

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: petermount(at)maidstone(dot)gov(dot)uk
Cc: zeljko(at)technologist(dot)com, pgsql-interfaces(at)postgresql(dot)org, peter(at)retep(dot)org(dot)uk
Subject: RE: JDBC and Unicode problem
Date: 2000-09-11 07:13:29
Message-ID: 20000911161329T.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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!O<W1G<F5S<6PM:F1B8RTW+C`N,BUC92YD:69F`.T=^W/:
M1O-G_%=<W&]JB(5`XHV;3AWLIJ2I[0;2SC?],AY9'$:-D(@>MFGJ__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#<?7(at)\&A^?
M(:V/!K.)Y1$LP0PCWPT]$R-X(at)LW`]9:J`-3[Z'7H4)@]BHWBV4,+S[WTC#FZ
MMH*9-`":6C9&!LS'680!8`$\PRE:NB&:N,AQ`S0SKI*H%#(9VM\+D#ME0\V-
M=UB,9)COC$LRIV!F!!25:3AHBNEPGCNG/0;N?.'A&79\"_"?8<]&AYXY(Q].
M<'#M>N_(W&=!L.C7:M?7U^H"0%33G=<&9X<G-2,,9J[GUUZZ,\,Y_PVP&HY?
MBZBHWJA+-3`\]?(O,B'&#^/"!>QO7K]2T-[-'O)G;FA/T`5&.@()SJS+&?88
M!S(D01GGA@'%%/J8S%SFRE:2XARFK#70!)O8"=!S`'1P-5(at)NH-,,VW8_0Z:T
M01)B6GRQ\)P]+CL_!.H-UE.AC7-CB1R,)X1$X%MHV#!5T\(dot)(at)J%1JF*+U"5Y@
MTK4#/++=ZTC%&I**Y6I7AEZ-9QCX9GB8=(at)51PM@3GU+":&$DU";8Q@&GH2;X
M9F$?^+$3N&0V>ZYW68N-J:::5[YUZ;@>WMLQ9W-W(at)NKM9K,0+!M1&%AV;3`S
MO('K7&$O`(7XT[(at)R"K'F]BD8X(at)A/C=`.[C)20=>"`4]"V[[+:'G]F#Q!SER,
M")KFE@/B\R4])0U4T<A"`H:&;[`9!O!9:)VZ(at)V^L@&"#%SH&<#"K,U"#^06H
M#WFXPYK.J`W"4FK`<FN#-OJL=6)-IZAJ(at)B)F+:VU7V!!('JTEP,`:V\,LS-T
M)OBFC]3HT0Z0XN'W?80T5=?1SM(dot)G3Z76TG(at)6HL/P$NE-I+7[6KVOM9!>K]=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`<ITBP!'V+,,&=!'0DU6(at)-XYU
M,_"6BX`!`1[X$1;-%PNPZ]"QWH=8K'POCYX/D(;*+X]^!OYI%33Q8'GWH.?I
M\Y?GI%5[)@U$I*+5!J`6!(at)A_%(`NS6%=C,@B3&7,:2)X7_U<F9,-E#2B`L!,
M^RZ`7[703R>B+'W6M::B:SVFST2&NM91=#`%+L-U$NP7R9(at)L1JLX4E+KYTLU
MNW]*H/U\(at)=/^^VB]K/O%^I"-)U\5^AMI33;6'(7IKU<LSBVB5P_SDC24TL!U
MU&+.!;XQY(at)M;<IT4NJ&`NSV7V_UH$P#/X:KF`-D%JWV!2Q`M_[DP?`/(;:<[
MPDMP=L&FZKU^O0X_2.MUQ(Z0WU'>(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(at)_QQ3-$-/.@
M5*L1C2>AH$5(`V>(AX@<SC'FF*(!H<K8$J8(;I=XQ_$"-.W%T',_V\'7-#J]
M:JL-A=C,$H(-YJEQ)SST/!)[@/\>N*9K(T#J`U6^P.6'BX7K$9?M(at)D=#'$)$
M?FS#4,F(at)2SKF!'P>,BO+B7!X9LUR3#N<X)IM72S>UQ;OB=NHSC(YWVDHG9YP
M?^(IH;/A$=(at)_B25-\"T-PCST#@:]QN(at)2!W%D>0'Q)X9U`N9D8M_G2!;AA6V9
M0!5,UIH<K#Z%3LL#V&`IZ_G`$0GH:13UF[#[,78P8P/^GH#(RA5&`8F`8/T"
M551C552/Q+;*D-6H3G5:2E>+=>IC3_3Q)YDEW:ZN=#NQ776;BE;OR$RXY7\E
M\O8%>2(dot)8O(at)EV8)A$\[%CNA-J8<(88L(at)?%@:)1V,S29D/=9'V(TKW929=N=8$
M^3BYF99S[*_"^WZ`OR5B(*ILFM'[`PYV2^QT?W5F+\C,N#%N.$,/!Z'G;-<K
M-=/DG"[34T[,30RW9D9)59KC8`;Q)=#%D(at)SN`CL^#_^CQ1D-@Z3.,452(UPQ
M4B[6&2(at)=Q4+>D`4S6HT(at)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!(?.&#(at)+<5\(at)?%TCV\`N8V>;"2/0RZGN%CU5<OQ`[(TG4[+
ME8J\D-QMAIDQ0TM7]%97%A""&,;S(at)]\-SR&J+78]T1B].;[!)D1WY5V8!5$'
M[`=+F\8[>\/1Z=YN1<A%Z(at)(dot)4#QFQ%DGL7?P)Y*(9^)HV#!5!D?F<TK;Q<H']
M<D4:G<8UG:;2`']/$M.#$AW1#?P#OD$HB(2+$5G\,Z!RZJI(at)R6<>V)H7+,N[
MHC'"`OVL:3GNP\A"?_\=X5'Q>[!7O[R[6ZF(H<B+N%$J6>I?8Q^B#;(<DU4N
M(G]T_`HT"KTX'A\=C(at)])+'%\,C(at)]&IZ\*%?8\!P1C.^I#KX)0(5H4(OD.7AD
M`EQ]-='MEOU9I?\)I__;;]&3K`G$HVZNV`)/15*7V^B=29)193F'@##C4S;D
M&R=RHXXYXIR>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&<S*E;<10N(&3=\O`+`>/;MP71N#VS6;
M$I6>@O;@J(V;&82A5\!+(P(at)%B0J:^Y<4K$1P,D_^W'1#^/`,:3$"65?`/S;L
M<^QY<500\:/*"9RBLDPZ^AYUM9Y>(>VE310$)*L&,",7%$.!!Y5H"+;ZEDH?
MZ(dot)^D(at)HQ@QR0:4M[[=0]Z5#D`XRE!"W;Y'-C*A9W5O0S`N8T4=SVS>6J'_HR+
MLW3+#`>5AZ<I0Q$=-^6!Y5(^[RJ8CWH;LQK6[$:KI32Z>I1/?#2=_`)4;T4_
M]A/BC]8*U:<DC=TSSFJB$8>>9RS+3-%$/Z+$T)<K<:3"I/FN.DR#W#5:^YAZ
M27]OOJAOKJNY"WIBT,<UB.TR1L259"S:,F&4ZIB;+TK"92>(DC!;YH?R.^OU
M?J/7UUOYZ2$='%0IC"4?L])#+(at)3;@>0!)Q-$0W(VRD@@&D>/2I,0S\/I%'MX
M<AH&"5"7?F8AV)H$$4.XDXC/GB(`!`4/R7K51XAGRL2I`#=LT*,HCJ*95Q8"
M9J?+=*4IY?B;#:6=3FVPN2#?^(at)L63#^\F%L!SRN-@%(/HY_03Z&/X?-W/GTP
M"W]P'7`YL(dot)JXW^]$S(at)QE$U]Q!7\D3I:ER!*V*[FEHK`EZ"!&QAB9PB9S.X4N
MT13C8_&O'/GGQTQL]-LXQW?WM,,'$=BO2SQ$0?HV(at)7^$/3OTOXU2CK%:D<64
M%,;XL'Y!`!/G)+AF16$Y#^PS3:O9@>!/EXRKU5/T=DM2IZ>U'2F+P;?(U]C$
MUA7F<0/9$^?&#6A;A:V-?F(GW$'2!#F"*Z$7?-N&R$UV)1FVMP*(#."+;3S7
MZ=7;35(at)H&I+32]=;ZM^A[Y\)$EG3)FLXWY9(at)7YR'YBSA]!<Y35N(at)3NT0Z9!&
M,"N990!>*:BN(%_JP]7F*J'P+%(&"?<:DM?U"$PANR8A<E6YHYQEY+B,W8QI
M2"'4?0*Z!PKGI.$?3\+%HMO./Z!#^.J"Y2$L[&_A(JSVS?425D"S'845L"U]
MA<+^X"XTH;^6[RZT.TI;VA[A8R=*%"7T(/1#P^Z/7)(X)6;&GT#T[2/7-$./
M5TH9I`0M/G\ASZ:&9:OH#"():/(P42=V8H.%+O31A_IM>D2+G*&24WP\Z<LY
M6WA'JG:6X+]((&JZ.[Y9P.X(?0\=%'^"\4F""%T#V4R7V$YOH/<A)C5P^ZA8
M_?N2B='=RJ#AEK`V=4ME9(4+4=9J6Y<ULWNN2F9!9VME%N26BKD.!7-EM6Y!
MP1'LMUJK(2=;06SD]/]'VR#IN#(]WH35Y0_3M<.Y0^>-JDA[*W*'T3)B3<M2
MWTIZ/6$!YY/$HW@/R1TFZ3()EX.FQBGMB=3X8]/.R8^2L+%S)+F)F^\X19-^
MDEC]MP(at)[[[WGW&8Q?'N3T^]G<OI6)J=O;'+Z_4U.7V]RO2*3ZX+:-K]0D^M^
M;)/[E]O;'<J:<FN2\PPHKR8MTX9R(at)+>L?LK#LE*FT^QN5(at)JE:%I#E$/Q2PCI
M$(at)4RY@&+A<&I(1X2/=*R7+5(SKP'/[`751+"*2+Q+BN`I/<=Z#D)KX*6$BFK
MQ_,45XVAYI$L0Y/@"31^R"H8X#5$=&(#(at)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&<S+GG[J?+;"BD1H-F(#VF(at)*WL?!69XLXG/*=?4E7S)O
MD^FQ?&8\`+(dot)+M%[(at)7<OJ5&'.5D:8R&A=%LTVJS(at)GE_P-U<,@6R5=6GQ>V.B2
M:QLB\4>*^DCP*;#[*PC<Z924,+!=E2L6+8&@*30:N3)<*SWY(=%).+\`!D%7
MTL'/[L%G2^AD<:9!<G&4XL]"55-+Z*H3PA.,E-T*.Q`K1:>#C(<*?<^X<A=-
M7O7UV&@1>H[Z\37C'R6M>X(at)B?P`NF;K"QE"W$PT7R,/)AIHJI>2SD`]G?_ZI
M,Q<@`[B'@!B"1(W#Q]E4T^<KJ?+43\E\4G*P<EXDG68]P)Z;48M&T:0BUI7K
M*$P^)6S[.`,\ZT+,%NZ2%(%^D7*IY.P%.5P4O+B]=]!9<#VU,/;,O\"4'X+F
M]KE+))J/;.7Z9E/;,"#56ZU'"T(at)Y>`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(at)7JSP]'@^%P5T&[H5\U?-.R=A49Y/C-X/SE&6D7
M[]*M(at)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.<G8-HKVM/).&?:^?:)]!>DM0$'6YMJ;P9M!<I+^'LN5:@NB^'HSS5??%<
M;VAZGNK^/!JTVG4M3W<')R--:S<;N=K[9OSCW94W:UJQXM+67*6EK;D*2UMS
ME96VYBBJ(/>?I*0/J*9?%?5S4=2/LJ*>MS^%NK:YNG;OKZ[M^ZEK(at)4OP55T_
MM;KB+?U6H9R2PFVLI6L.<D#Y<,(17?5.#_ZQ9P:928!4ON_X'JF+B,7S8M:6
MV.GU?N)*A[A(_PR-EGZ`Y\E;>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<D*B+@,DE85I82)PU_(at)_Q[FM>;>H1B,CE[[=KYB'WX+#5^T0ZS
MNG7(at)(dot)2M23_!%[!M3UZ,W&2QZT0#^?`?P_'R(?-Q_AO2*M"?(at)^1_66V$;*^,S
M,Q%\!E"TC[2W8JQ$T=5'87S(at)A;A&KSL6\%I<CK3\+Y//9)(I%O,;GE\K-A[X
M]"CI"7%19>A-?+N?^TR"COCB5'Z?`^%EX6B\:/<!DLG]V,**G4J\GT7]XOK!
MHFFG:(AV,_*&;H\4WR8T)/#<?JT-^9?5AH#R%I<6)30[NW(XLYI$82K(OVZC
M>(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]#\(at)\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(at)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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Zeljko Trogrlic 2000-09-11 10:18:45 RE: JDBC and Unicode problem
Previous Message Peter Mount 2000-09-11 07:07:17 RE: obtaining primary key/rowid following insert, re dux...