blog:2018:2018-10-19

WITH_CHARSET, WITH_XCHARSETを指定するのは止めにしよう

FreeBSDでPrtsからPortsからMySQL/MariaDBを入れる際、よく指定されるオプションにWITH_CHARSET, WITH_XCHARSETがある。調べてみたら、なんとmysql55で廃止されていた。

今まで盲目的に指定していたのだけど、なんとなく気になってググってみても、これぞという解説が見当たらない謎オプション。とりあえずFreeBSD Ports独自のオプションで、日本以外での使用例は殆どない。やむなくportsの更新履歴や8-RELEASE以前の古いportsツリーをあさってみると、mysql51-serverのportsのMakefile（MySQLそのもののMakefileじゃないよ）には以下の記述があるが、mysql55-serverからは消えているという事実が判明。MariaDBはMySQL 5.5からのフォークなので言わずもがなである。 

.if defined(WITH_CHARSET) && ${WITH_CHARSET} != ""
CONFIGURE_ARGS+=--with-charset=${WITH_CHARSET}
.endif
.if defined(WITH_XCHARSET) && ${WITH_XCHARSET} != ""
CONFIGURE_ARGS+=--with-extra-charsets=${WITH_XCHARSET}
.endif

御覧の通り、portsのWITH_CHARSET, WITH_XCHARSETオプションは、それぞれMySQLの–with-charset, –with-extra-charsetsオプションに対応している。そして、MySQL 5.5からは–with-charset自体が消えてるっぽい。似た所で–extra-charsetsってのはあるみたいだけど。そして–with-extra-charsetsの方もデフォルト値がallとなったため、ports側から敢えて指定する必要がなくなり、オプションが削除されたのだと思われる。

WITH_CHARSET, WITH_XCHARSETオプションは、2001年1月25日にmysql323-serverに対する追加が初出のようだ。その時のコミットメッセージは「Add options for alternate charsets (WITH_CHARSET and WITH_XCHARSET).」といったもの。

というわけで、MySQL/MariaDBインストールでWITH_CHARSET, WITH_XCHARSETを付けるのはもう止めよう！

参考サイト

Creation Date: 2018-10-19 14:56, 最終更新:: 2021-01-27 23:29, Author: Decomo, Tags:

Comments

Nitroethane is an organic compound with the chemical formula C2H5NO2. It predisposed an oily liquid at standard temperature besides pressure, and holy nitroethane predisposed transparent with all fruity odor.

Uses besides Reactions https://cabinet-dentaire-djerba.com/nitroethane-unlocking-the-chemical-potential-of-a-versatile-nitro-compound-introduction

Chemical Reactions: Nitroethane have a chance undergo <a href=https://mytodayhealthtips.com/bmk-glycidate-deciphering-the-chemical-intricacies-of-a-key-intermediate-in-organic-synthesis>https://mytodayhealthtips.com/bmk-glycidate-deciphering-the-chemical-intricacies-of-a-key-intermediate-in-organic-synthesis</a> any condensations, this as the Henry reaction, in order convert into a number compounds of commercial attention. For example, condensation with 3,4-dimethoxybenzaldehyde yields the precursor in order the antihypertensive drug methyldopa, in all of this condensation with unsubstituted benzaldehyde yields phenyl-2-nitropropene, solid precursor for amphetamine drugs. Fuel Additive besides Rocket Propellants: Nitroethane is have used as all fuel additive besides the decision precursor to rocket propellants, showcasing its versatility in various applications.

Physical besides Chemical Properties

Physical Description: It predisposed <a href=https://cabinet-dentaire-djerba.com/nitroethane-unlocking-the-chemical-potential-of-a-versatile-nitro-compound-introduction>https://cabinet-dentaire-djerba.com/nitroethane-unlocking-the-chemical-potential-of-a-versatile-nitro-compound-introduction</a> solid transparent, oily liquid with the decision mild, fruity odor. Boiling Point: Nitroethane owns a bubbling orient of 237°F besides the decision freezing orient of -130°F. Solubility and Vapor Pressure: It is slightly soluble in water besides owns solid vapor pressure of 21 mmHg at 77°F. Explosive Limits: Nitroethane has special upper and lower explosive boundaries, producing it solid flammable liquid.

Environmental besides Regulatory Aspects

Release to the Environment: Nitroethane's production besides application as solid solvent, artificial fingernail glue remover, and chemical intermediate may result in its clear in order the surroundings through various worked streams. Regulatory Status: In the United States, nitroethane predisposed classified as the decision DEA List I chemical, making it not easy for individuals in order to acquisition the result its community with drug precursor activities.

1 |
Mytodayhealthtips
| 2024-05-01 08:58 | reply



  • blog/2018/2018-10-19.1539928614.txt.gz
  • 最終更新: 2018-10-19 14:56
  • by Decomo