How can I set up multilingual support for my database?

A clean schema is the foundation of global database support. The most common approaches are a translation table (one row per locale per content item) or a JSON column that holds all translations in a single field. For example, a products table might have a name_translations JSON column storing {"en": "Pricing", "fr": "Tarification"}. Choose the method that matches your query patterns and the number of languages you plan to support.

Once your database stores content in multiple languages, you can surface it through a knowledge base that understands locale. Chatref lets you upload your structured content and automatically serves answers in the user's detected language. The agent pulls from the same set of docs, so you maintain one source of truth while supporting multiple languages across your help center and website widget.

The Chatref website widget detects a visitor's browser language and responds in that language when the matching content exists in your knowledge base. This means a user in Mexico gets Spanish answers, while a user in Germany sees German, all from the same widget snippet. You don't need separate bots or duplicated training material to offer global database support.

Multilingual chat works best when your database and knowledge base stay in sync. When you update a product description in your database, refresh the corresponding doc in Chatref so the agent always gives accurate answers. The platform supports up to 11 languages out of the box, so you can serve every region without building separate language-specific agents.

How to set up multilingual chat Upload your translated content to Chatref as separate docs or as a single doc with locale markers. The agent automatically detects the user's language from their browser or chat context and responds in that language when the content is available. No extra configuration is needed beyond adding your multilingual source material.

Support global users Global users get help in their own language through the Chatref website widget. The widget detects their locale and matches it to the relevant content in your knowledge base. If a translation is missing, it falls back to your default language, so no question goes unanswered.

Multilingual database help If your database stores content in multiple languages, export it as structured files (like JSON or CSV) and upload them to Chatref. The platform indexes each locale separately, so queries in French hit the French content, and queries in English hit the English content, all from the same agent.