[pgsql-jp: 42115] Re: ポスグレ初心者の疑問（初投稿です）

[平川 昌幸（DCS ＨＲ開発部）]

$B$42sEz$$$?$@$-$^$7$?3'$5$^(B

$B<ALd$7$?J?@n$G$9!#(B
$B3'$5$^$NJV?.$r;29M$K!"FbIt$G8!F$$7$FBP1~$r?J$a$F$_$h$&$H;W$$$^$9!#(B
$B4pK\E*$JJQ49$d3HD%J}K!$J$I$465<($$$?$@$-!"BgJQ;29M$K$J$j$^$7$?!#(B
$B$"$j$,$H$&$4$6$$$^$7$?!#(B


-----Original Message-----
From: pgsql-jp-bounces ＠ ml.postgresql.jp <pgsql-jp-bounces ＠ ml.postgresql.jp> On Behalf Of TAKATSUKA Haruka
Sent: Monday, November 11, 2024 10:04 AM
To: PostgreSQL Japanese Mailing List <pgsql-jp ＠ ml.postgresql.jp>
Subject: [pgsql-jp: 42113] Re: $B%]%9%0%l=i?4<T$N5?Ld!J=iEj9F$G$9!K(B

$B9bDM$H?=$7$^$9!#(B

PostgreSQL$BB&$G2r7h$9$k$H$7$F!"(B
CONVERSION ($BId9f2=J}<0JQ49(B) $B$O3HD%2DG=$G$9!#(B
https://www.postgresql.jp/document/16/html/sql-createconversion.html

$B3HD%%b%8%e!<%k$H$7$F!V(B4.$B!W$r$d$l$P!"K\BN%3!<%I$K?($i$J$/$F:Q$_$^$9!#(B

$B;d$O(B eudc $B$H$$$&(B UTF8 $B"N(B SJIS $B$K30;zNN0h$NJQ49$r2C$($k3HD%$N(B
$B%U%)!<%/$N#1$D$r7QB3%a%s%F%J%s%9$7$F$$$^$9!#(B
  https://github.com/harukat/eudc
$B%*%j%8%J%k$N(B CONVERSION $B$+$i$A$g$C$H$@$1JQ99$7$?$b$N$r2C$($k3HD%$r(B
$B=q$/$N$K;29M$K$J$k$+$H;W$$$^$9!#(B



On Mon, 11 Nov 2024 08:30:41 +0900
Kubo Takehiro <kubo ＠ jiubao.org> wrote:

> UTF-8 $B$+$i(B SJIS $B$X$NJQ49%F!<%V%k:n ＠ .;~!"JQ49 ＠ h$,(B2$B$D$"$k$H$-$O0J2<$N(BURL$B$K(B
> $B5-:\$5$l$?HO0O$,=|30$5$l$k$h$&$G$9!#(B
> https://github.com/postgres/postgres/blob/REL_17_0/src/backend/utils/mb/Unicode/UCS_to_SJIS.pl#L22-L26
> 
> $B!V-5!W(B(U+2160) $B$NJQ49 ＠ h(B 0x8754, 0xFA4A $B$N$&$A!"(BNEC$B3HD%J8;z$N(B 0x8754 $B$,=|30$5$l!"(B
> IBM$B3HD%J8;z$N(B 0xFA4A $B$,;D$k$?$a!"(BIBM$B3HD%J8;z$N!V-5!W$K$J$k$N$G$7$g$&!#(B
> 
> $BBP:v0F(B
> 1. PostgreSQL$BB&$NJ8;z%3!<%I$r(BSJIS$B$K$7$F$b$i$$!"J8;z%3!<%I$NJQ49$r2sHr!#(B
>     $BM}M3$,$"$C$F(BUTF-8$B$K$7$F$$$k$N$J$iL5M}$G$7$g$&$1$I(B
> 2. PostgreSQL$BB&$GJ8;z%3!<%IJQ49$r$9$k$N$G$O$J$/!"%W%m%0%i%`B&$G9T$&!#(B
>    $B%W%m%0%i%`$+$i$N@\B3$NJ8;z%3!<%I$r(BUTF-8$B$K$7$F!"(BSQL$B<B9TA0$K$O%W%m%0%i%`B&$G(B
>    SJIS -> UTF-8 $B$NJQ49$r9T$$!"%/%(%j$N7k2L$J$I$O%W%m%0%i%`B&$G(B UTF-8 ->
>    SJIS $B$NJQ49$r9T$&!#%W%m%0%i%`B&$GJQ49$9$k$N$J$i$P9%$-$JJQ49 ＠ h$rA*$Y$k(B
> 3. PostgreSQL$B$+$i(BSJIS$B$NJ8;zNs$r<u$1<h$C$?8e!"(BIBM$B3HD%J8;z$N!V-5!W$r(B
>     NEC$B3HD%J8;z$N!V-5!W$KJQ49!#(B
>    $B$?$@$7!"L5>r7o$K(B 0xFA, 0x4A $B$N(B2$B%P%$%H$r(B 0x87, 0x54 $B$N(B2$B%P%$%H$KJQ49$9$k$H(B
>    $BNc$($P!VF|(BJ$B!W$N!VF|!W$N(B2$B%P%$%HL\(B 0xFA $B$H(B J (0x4A) $B$bJQ49BP>]$H$J$C$F$7$^(B
>    $B$&$N$GCm0U!#J8;zNs$N ＠ hF,$+$iJ8;z6-3&$r9MN8$7$D$DD4$Y$F$$$/(B
> 
> $B<YF;$J0F(B
> 4. PostgreSQL$BK\BN$K<j$r2C$((B UTF-8 $B$+$i(B SJIS $B$X$NJQ49%F!<%V%k$rJQ99(B
>   unicode.org $B$+$i(B CP932.TXT $B$r%@%&%s%m!<%I$7(B
>   src/backend/utils/mb/Unicode/UCS_to_SJIS.pl $B$r=q$-49$($F<B9T$7!"(B
>   src/backend/utils/mb/Unicode/utf8_to_sjis.map $B$rCV$-49$($F(B
>   PostgreSQL$BK\BN$r:F%S%k%I(B