MARKETPLACE
PLUGINS
TEXT CONVERT TO SHIFTJIS FOR SORT
text convert to shiftjis for sort logo

text convert to shiftjis for sort

Published February 2025
   •    Updated March 2026

Plugin details

📌 Overview (概要) This plugin converts input text into Shift_JIS encoded hexadecimal strings, making it easier to sort Japanese text correctly in environments where default sorting methods may not work properly.
By using this plugin, you can avoid issues where kana (hiragana & katakana) are sorted incorrectly due to differences in character length.

このプラグインは、入力されたテキストを Shift_JIS 文字コードの16進数表現に変換するプラグインです。
これにより、デフォルトのソート機能では適切に並ばない日本語の並び順を、正しい辞書順に補正することができます。
特に、かな・カタカナの文字数による誤った並べ替えを防ぎ、より自然なソートを実現します。

🔧 Features (機能)
✅ Accurate sorting for Japanese text

Converts text into Shift_JIS hexadecimal format, ensuring that kana and kanji are sorted correctly.
Fixes issues where katakana words of different lengths are incorrectly ordered.
✅ Lightweight and fast processing

Uses server-side execution for optimal performance in sorting large datasets.
✅ Simple integration

Just pass the input text and get a Shift_JIS encoded key that can be used for sorting.
✅ Supports various text types

Works with kanji, hiragana, katakana, and mixed text.

📌 Example Use Cases (活用例)
✅ Sorting Japanese Names Properly
🔹 Default sorting issues:

Input Name Default Sorting (UTF-8) Shift_JIS Sorting (Correct)
アイウ アイウ アイウ
アオ アイウ アオ
アカ アオ アカ
🔹 Using this plugin, names are ordered correctly in Japanese dictionary order.

✅ Sorting Product Lists with Mixed Japanese Characters
When product names contain kanji, katakana, and hiragana, default sorting may not work correctly.
This plugin ensures accurate ordering, just like a Japanese dictionary.
✅ Correct Alphabetical Sorting for Multilingual Data
Works well with multilingual applications where English and Japanese text need to be sorted correctly.
💡 Why Use Shift_JIS for Sorting? (なぜShift_JISを使うのか?)
Most databases and Bubble's default sorting use UTF-8, which does not follow the expected order for Japanese text.
By converting text to Shift_JIS hex values, we ensure that sorting behaves as expected for Japanese dictionary order.

通常、Bubble やデータベースのソートは UTF-8 に基づいており、日本語の辞書順にならないことがあります。
このプラグインでは、Shift_JISの16進数表現をソートキーにすることで、正しい並び順を再現できます。

🛠 Technical Details (技術詳細)
Input: Any Japanese text (kanji, hiragana, katakana, mixed)
Output: Shift_JIS-encoded hexadecimal string
Processing: Server-side conversion using iconv-lite
Usage: Apply the hex string as a sorting key
📢 Notes (注意点)
⚠️ Bubble does not support direct Shift_JIS encoding, so this plugin processes text on the server-side.
⚠️ Do not use the output for display purposes, as it is not human-readable. It is meant only for sorting.

Bubble は Shift_JIS を直接サポートしていないため、このプラグインでは サーバーサイド処理 でエンコードを行います。
また、出力される文字列は ソート専用のキーであり、表示目的では使用しないでください。

🚀 Get Started Today!
Install the ShiftJIS Sort Key Generator and improve your Japanese text sorting accuracy! 🚀

$3

One time

stars   •   0 ratings
1 installs  
This plugin does not collect or track your personal data.

Platform

Web

Contributor details

Ryouta Suzuki logo
Ryouta Suzuki
Joined 2020   •   1 Plugin
View contributor profile

Instructions

📖 How to Use (使い方) 1️⃣ Install the Plugin
Add the "ShiftJIS Sort Key Generator" plugin to your Bubble application.
2️⃣ Add a Server-side Action
In your workflow, select “ShiftJIS Convert for Sorting” as a server-side action.
3️⃣ Provide Input Text
Set the input text that you want to convert.
4️⃣ Use the Output for Sorting
The plugin returns a Shift_JIS-encoded hexadecimal string that can be used for sorting.
Apply the output as a sorting key in a database query or repeating group.

1.textに対象の文字列を入れる。
2.返り値でshift-jisを受け取り、利用する。

Types

This plugin can be found under the following types:

Categories

This plugin can be found under the following categories:

Resources

Support contact
Documentation
Tutorial

Rating and reviews

No reviews yet

This plugin has not received any reviews.
Bubble