Skip to Main Content
  • Questions
  • Can we convert/translate Arabic to English

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Darshankumar.

Asked: July 07, 2022 - 8:10 am UTC

Last updated: July 12, 2022 - 1:24 pm UTC

Version: Oracle Database 19c Enterprise Edition (19.0.0.0.0)

Viewed 1000+ times

You Asked

Hi Team,

I just wanted to know if we can convert a whole string of data residing in Arabic and can we convert or translate it into English?

So I have data in one column which is Arabic String, need to translate this into English via SQL.

Thanks,

and Chris said...

There is no in-built functionality in Oracle Database to translate text. You'll have to find a service/program to do this or store the translations yourself.

If going the DIY route, create tables to store the a lookup code for each item you want to translate and the text in each language you want to support.

For example:

create table translations (
  text_code    varchar2(30), -- lookup code for the text item
  english_text clob,
  arabic_text  clob,
  ...
);


OR

create table translations (
  text_code    varchar2(30), -- lookup code for the text item
  language_code varchar2(2), -- EN, DE, AR, etc.
  text          clob,
  ...
);

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Darshankumar Prajapati, July 12, 2022 - 9:30 am UTC

Thank you so much Chris for the clarification :)
Chris Saxon
July 12, 2022 - 1:24 pm UTC

You're welcome

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.